Advertisement
Guest User

Untitled

a guest
Jan 20th, 2017
100
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.84 KB | None | 0 0
  1. Tested with PostgreSQL 9.3.
  2.  
  3. === Sql Script Body To Test Example ===
  4. \setrandom u1v 1 100000
  5. \setrandom u2v 20000 20999
  6. \setrandom u 1 50000
  7. \setrandom r1 20000 20999
  8. \setrandom r2 20000 20999
  9. \setrandom r3 20000 20999
  10. \setrandom r4 20000 20999
  11. \setrandom r5 20000 20999
  12. \setrandom r6 1 100000
  13. \setrandom r7 1 100000
  14. \setrandom r8 1 100000
  15. \setrandom r9 1 100000
  16. \setrandom r10 1 100000
  17. select * from foo where (u1 = :u1v and u2 in (:r1, :r2, :r3, :r4, :r5)) or (u2 = :u2v and u1 in (:r6, :r7, :r8, :r9, :r10));
  18.  
  19. === Pgbench Run Line ===
  20. -c = number of concurrent database clients
  21. -f = script file path
  22. -j = number of threads (the clients are evenly distributed among this number of threads)
  23. -n = don't run VACUUM (docs require it be set in case of custom a script)
  24. -U = username
  25. test1 = database name
  26. pgbench.exe -c 10 -f C:/test.sql -j 10 -n -U root test1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement