non durable read benchmarks

RESULTS

synchronous_commit = off

[serial]

tps = 2555.469688 (excluding connections establishing)
tps = 2627.757181 (excluding connections establishing)
tps = 2727.293028 (excluding connections establishing)
tps = 2511.608749 (excluding connections establishing)
tps = 2440.086908 (excluding connections establishing)
tps = 2534.304940 (excluding connections establishing)
tps = 2802.654885 (excluding connections establishing)
tps = 3025.113613 (excluding connections establishing)
tps = 2469.327236 (excluding connections establishing)
tps = 2417.558457 (excluding connections establishing)

2611 tps

[parallel]

tps = 10939.900292 (excluding connections establishing)
tps = 11604.491669 (excluding connections establishing)
tps = 10122.480219 (excluding connections establishing)
tps = 12160.670785 (excluding connections establishing)
tps = 12453.052604 (excluding connections establishing)

synchronous_commit = local_non_durable_reads

[serial]

tps = 3026.797494 (excluding connections establishing)
tps = 2781.670260 (excluding connections establishing)
tps = 3000.768869 (excluding connections establishing)
tps = 3393.437456 (excluding connections establishing)
tps = 3421.598323 (excluding connections establishing)
tps = 3527.308845 (excluding connections establishing)
tps = 3655.200678 (excluding connections establishing)
tps = 3612.364030 (excluding connections establishing)
tps = 3844.902303 (excluding connections establishing)
tps = 2954.324230 (excluding connections establishing)

3321 tps

[parallel]

tps = 8877.927307 (excluding connections establishing)
tps = 9089.016008 (excluding connections establishing)
tps = 7409.157495 (excluding connections establishing)
tps = 8609.570746 (excluding connections establishing)
tps = 8825.346347 (excluding connections establishing)

synchronous_commit = on

[serial]

tps = 1273.428938 (excluding connections establishing)
tps = 1288.153932 (excluding connections establishing)
tps = 1361.350573 (excluding connections establishing)
tps = 1281.927248 (excluding connections establishing)
tps = 1244.184723 (excluding connections establishing)
tps = 1316.670978 (excluding connections establishing)
tps = 1243.917845 (excluding connections establishing)
tps = 1213.317540 (excluding connections establishing)
tps = 1295.518257 (excluding connections establishing)
tps = 1312.851348 (excluding connections establishing)

1283 tps

[parallel]

tps = 6997.083403 (excluding connections establishing)
tps = 8620.450053 (excluding connections establishing)
tps = 9124.355628 (excluding connections establishing)
tps = 8356.261220 (excluding connections establishing)
tps = 8869.885429 (excluding connections establishing)

run_transactions_parallel.sh

#!/bin/sh
psql -p 5433 test < setup.sql
pgbench -t 40 -n -j 128 -c 128 -f transaction_parallel.sql -p 5433 test

run_transactions_serial.sh

#!/bin/sh
psql -p 5433  test < setup.sql
pgbench -t 120 -n -j 128 -c 128 -f transaction_serial.sql -p 5433  test

setup.sh

#!/bin/bash
set -e
rm -rf data
/usr/local/pgsql/bin/initdb -D data
cp postgresql.conf data/
/usr/local/pgsql/bin/postgres -p 5433 -D data
psql -p 5433 -c 'create database test' postgres

setup.sql

drop table if exists counters;
CREATE TABLE counters(id int primary key, counter int);
insert into counters(id,counter) select generate_series(0, 128), 0;

transaction_parallel.sql

\setrandom client_id 1 128
UPDATE counters set counter = counter + 1 where id = :client_id;

transaction_serial.sql

UPDATE counters set counter = counter + 1 where id = 0;