bench.pgbench.results.txt

HEAD
----------------------
pgbench (17devel)
transaction type: bench.pgbench
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
maximum number of tries: 1
duration: 60 s
number of transactions actually processed: 15192
number of failed transactions: 0 (0.000%)
latency average = 3.965 ms
initial connection time = 2.786 ms
tps = 252.198398 (without initial connection time)
statement latencies in milliseconds and failures:
         0.001           0  \set keyid random(1, 10000)
         0.151           0  SELECT id, block_range FROM test_dataset WHERE keyid = :keyid 
         3.814           0  SELECT id, block_range FROM test WHERE id = ':id' AND block_range && ':block_range';
pgbench (17devel)
transaction type: bench.pgbench
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
maximum number of tries: 1
duration: 60 s
number of transactions actually processed: 14854
number of failed transactions: 0 (0.000%)
latency average = 4.040 ms
initial connection time = 2.160 ms
tps = 247.550345 (without initial connection time)
statement latencies in milliseconds and failures:
         0.001           0  \set keyid random(1, 10000)
         0.153           0  SELECT id, block_range FROM test_dataset WHERE keyid = :keyid 
         3.886           0  SELECT id, block_range FROM test WHERE id = ':id' AND block_range && ':block_range';
pgbench (17devel)
transaction type: bench.pgbench
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
maximum number of tries: 1
duration: 60 s
number of transactions actually processed: 14860
number of failed transactions: 0 (0.000%)
latency average = 4.039 ms
initial connection time = 2.714 ms
tps = 247.580707 (without initial connection time)
statement latencies in milliseconds and failures:
         0.001           0  \set keyid random(1, 10000)
         0.151           0  SELECT id, block_range FROM test_dataset WHERE keyid = :keyid 
         3.887           0  SELECT id, block_range FROM test WHERE id = ':id' AND block_range && ':block_range';

btree_gist sortsupport
----------------------

pgbench (17devel)
transaction type: bench.pgbench                         
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
maximum number of tries: 1
duration: 60 s
number of transactions actually processed: 108857
number of failed transactions: 0 (0.000%)
latency average = 0.551 ms
initial connection time = 2.559 ms
tps = 1814.357057 (without initial connection time)
statement latencies in milliseconds and failures:
         0.000           0  \set keyid random(1, 10000)
         0.143           0  SELECT id, block_range FROM test_dataset WHERE keyid = :keyid 
         0.408           0  SELECT id, block_range FROM test WHERE id = ':id' AND block_range && ':block_range';
pgbench (17devel)
transaction type: bench.pgbench
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
maximum number of tries: 1
duration: 60 s
number of transactions actually processed: 109234
number of failed transactions: 0 (0.000%)
latency average = 0.549 ms
initial connection time = 2.141 ms
tps = 1820.620739 (without initial connection time)
statement latencies in milliseconds and failures:
         0.000           0  \set keyid random(1, 10000)
         0.142           0  SELECT id, block_range FROM test_dataset WHERE keyid = :keyid 
         0.406           0  SELECT id, block_range FROM test WHERE id = ':id' AND block_range && ':block_range';
pgbench (17devel)
transaction type: bench.pgbench
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
maximum number of tries: 1
duration: 60 s
number of transactions actually processed: 111429
number of failed transactions: 0 (0.000%)
latency average = 0.538 ms
initial connection time = 2.397 ms
tps = 1857.207357 (without initial connection time)
statement latencies in milliseconds and failures:
         0.000           0  \set keyid random(1, 10000)
         0.140           0  SELECT id, block_range FROM test_dataset WHERE keyid = :keyid 
         0.397           0  SELECT id, block_range FROM test WHERE id = ':id' AND block_range && ':block_range';