# # initialise small table... # $ pgbench -h /tmp -i -s 10 creating tables... 100000 of 1000000 tuples (10%) done (elapsed 0.10 s, remaining 0.94 s). 200000 of 1000000 tuples (20%) done (elapsed 0.21 s, remaining 0.85 s). 300000 of 1000000 tuples (30%) done (elapsed 0.31 s, remaining 0.71 s). 400000 of 1000000 tuples (40%) done (elapsed 0.40 s, remaining 0.59 s). 500000 of 1000000 tuples (50%) done (elapsed 0.49 s, remaining 0.49 s). 600000 of 1000000 tuples (60%) done (elapsed 0.59 s, remaining 0.39 s). 700000 of 1000000 tuples (70%) done (elapsed 0.68 s, remaining 0.29 s). 800000 of 1000000 tuples (80%) done (elapsed 0.77 s, remaining 0.19 s). 900000 of 1000000 tuples (90%) done (elapsed 0.86 s, remaining 0.10 s). 1000000 of 1000000 tuples (100%) done (elapsed 0.96 s, remaining 0.00 s). vacuum... set primary keys... done. # # readonly, 90 concurrent clients, 5 minutes run # $ pgbench -h /tmp -n -S -T 300 -c 90 transaction type: SELECT only scaling factor: 10 query mode: simple number of clients: 90 number of threads: 1 duration: 300 s number of transactions actually processed: 6905843 tps = 23012.221067 (including connections establishing) tps = 23044.131737 (excluding connections establishing)