+++++ dirname ./test_limit.sh
++++ cd .
++++ pwd
+++ DIR=/home/florisvannee/workspace/pg_dev/limit
+++ T=20
+++ /home/florisvannee/workspace/pg_dev/start.sh
++++ [[ 0 -eq 2 ]]
++++ [[ 0 -eq 1 ]]
++++ bdir=/home/florisvannee/workspace/postgres
++++ cd /home/florisvannee/workspace/postgres
+++++ git rev-parse --abbrev-ref HEAD
++++ totaldir=limit-release
++++ /home/florisvannee/install/limit-release/bin/pg_ctl -D/home/florisvannee/pgdata/limit-release -l /home/florisvannee/pgdata/limit-release/logfile -t 5 stop
pg_ctl: could not send stop signal (PID: 28145): No such process
++++ pkill -9 postgres
++++ /home/florisvannee/install/limit-release/bin/pg_ctl -D/home/florisvannee/pgdata/limit-release -l /home/florisvannee/pgdata/limit-release/logfile start
pg_ctl: another server might be running; trying to start server anyway
waiting for server to start.... done
server started
+++ pgbench -n -f /home/florisvannee/workspace/pg_dev/limit/test_fwd_eq.sql -T 20 postgres -Dnitems=1
transaction type: /home/florisvannee/workspace/pg_dev/limit/test_fwd_eq.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 20 s
number of transactions actually processed: 156764
latency average = 0.128 ms
tps = 7838.184195 (including connections establishing)
tps = 7839.331599 (excluding connections establishing)
+++ pgbench -n -f /home/florisvannee/workspace/pg_dev/limit/test_fwd_eq.sql -T 20 postgres -Dnitems=10
transaction type: /home/florisvannee/workspace/pg_dev/limit/test_fwd_eq.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 20 s
number of transactions actually processed: 131079
latency average = 0.153 ms
tps = 6553.920794 (including connections establishing)
tps = 6554.874046 (excluding connections establishing)
+++ pgbench -n -f /home/florisvannee/workspace/pg_dev/limit/test_fwd_eq.sql -T 20 postgres -Dnitems=100
transaction type: /home/florisvannee/workspace/pg_dev/limit/test_fwd_eq.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 20 s
number of transactions actually processed: 50692
latency average = 0.395 ms
tps = 2534.595231 (including connections establishing)
tps = 2534.967502 (excluding connections establishing)
+++ pgbench -n -f /home/florisvannee/workspace/pg_dev/limit/test_fwd_eq.sql -T 20 postgres -Dnitems=1000
transaction type: /home/florisvannee/workspace/pg_dev/limit/test_fwd_eq.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 20 s
number of transactions actually processed: 7621
latency average = 2.624 ms
tps = 381.043284 (including connections establishing)
tps = 381.093124 (excluding connections establishing)
+++ pgbench -n -f /home/florisvannee/workspace/pg_dev/limit/test_fwd_single.sql -T 20 postgres -Dnlimit=1
transaction type: /home/florisvannee/workspace/pg_dev/limit/test_fwd_single.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 20 s
number of transactions actually processed: 229991
latency average = 0.087 ms
tps = 11499.514293 (including connections establishing)
tps = 11501.125904 (excluding connections establishing)
+++ pgbench -n -f /home/florisvannee/workspace/pg_dev/limit/test_fwd_single.sql -T 20 postgres -Dnlimit=3
transaction type: /home/florisvannee/workspace/pg_dev/limit/test_fwd_single.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 20 s
number of transactions actually processed: 215881
latency average = 0.093 ms
tps = 10794.011481 (including connections establishing)
tps = 10794.899742 (excluding connections establishing)
+++ pgbench -n -f /home/florisvannee/workspace/pg_dev/limit/test_fwd_single.sql -T 20 postgres -Dnlimit=50
transaction type: /home/florisvannee/workspace/pg_dev/limit/test_fwd_single.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 20 s
number of transactions actually processed: 173334
latency average = 0.115 ms
tps = 8666.645542 (including connections establishing)
tps = 8667.882794 (excluding connections establishing)
+++ pgbench -n -f /home/florisvannee/workspace/pg_dev/limit/test_fwd.sql -T 20 postgres -Dnitems=10 -Dnlimit=1
transaction type: /home/florisvannee/workspace/pg_dev/limit/test_fwd.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 20 s
number of transactions actually processed: 117364
latency average = 0.170 ms
tps = 5868.162298 (including connections establishing)
tps = 5868.966227 (excluding connections establishing)
+++ pgbench -n -f /home/florisvannee/workspace/pg_dev/limit/test_fwd.sql -T 20 postgres -Dnitems=100 -Dnlimit=1
transaction type: /home/florisvannee/workspace/pg_dev/limit/test_fwd.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 20 s
number of transactions actually processed: 49578
latency average = 0.403 ms
tps = 2478.893661 (including connections establishing)
tps = 2479.258209 (excluding connections establishing)
+++ pgbench -n -f /home/florisvannee/workspace/pg_dev/limit/test_fwd.sql -T 20 postgres -Dnitems=1000 -Dnlimit=1
transaction type: /home/florisvannee/workspace/pg_dev/limit/test_fwd.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 20 s
number of transactions actually processed: 7897
latency average = 2.533 ms
tps = 394.817306 (including connections establishing)
tps = 394.874583 (excluding connections establishing)
+++ pgbench -n -f /home/florisvannee/workspace/pg_dev/limit/test_fwd.sql -T 20 postgres -Dnitems=10000 -Dnlimit=1
transaction type: /home/florisvannee/workspace/pg_dev/limit/test_fwd.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 20 s
number of transactions actually processed: 842
latency average = 23.775 ms
tps = 42.060903 (including connections establishing)
tps = 42.066652 (excluding connections establishing)
+++ pgbench -n -f /home/florisvannee/workspace/pg_dev/limit/test_fwd.sql -T 20 postgres -Dnitems=10 -Dnlimit=3
transaction type: /home/florisvannee/workspace/pg_dev/limit/test_fwd.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 20 s
number of transactions actually processed: 91328
latency average = 0.219 ms
tps = 4566.376538 (including connections establishing)
tps = 4566.973889 (excluding connections establishing)
+++ pgbench -n -f /home/florisvannee/workspace/pg_dev/limit/test_fwd.sql -T 20 postgres -Dnitems=100 -Dnlimit=3
transaction type: /home/florisvannee/workspace/pg_dev/limit/test_fwd.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 20 s
number of transactions actually processed: 21644
latency average = 0.924 ms
tps = 1082.149192 (including connections establishing)
tps = 1082.288793 (excluding connections establishing)
+++ pgbench -n -f /home/florisvannee/workspace/pg_dev/limit/test_fwd.sql -T 20 postgres -Dnitems=1000 -Dnlimit=3
transaction type: /home/florisvannee/workspace/pg_dev/limit/test_fwd.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 20 s
number of transactions actually processed: 2575
latency average = 7.769 ms
tps = 128.715772 (including connections establishing)
tps = 128.734108 (excluding connections establishing)
+++ pgbench -n -f /home/florisvannee/workspace/pg_dev/limit/test_fwd.sql -T 20 postgres -Dnitems=10000 -Dnlimit=3
transaction type: /home/florisvannee/workspace/pg_dev/limit/test_fwd.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 20 s
number of transactions actually processed: 263
latency average = 76.250 ms
tps = 13.114679 (including connections establishing)
tps = 13.116601 (excluding connections establishing)
+++ pgbench -n -f /home/florisvannee/workspace/pg_dev/limit/test_fwd.sql -T 20 postgres -Dnitems=10 -Dnlimit=50
transaction type: /home/florisvannee/workspace/pg_dev/limit/test_fwd.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 20 s
number of transactions actually processed: 55591
latency average = 0.360 ms
tps = 2779.537585 (including connections establishing)
tps = 2779.926201 (excluding connections establishing)
+++ pgbench -n -f /home/florisvannee/workspace/pg_dev/limit/test_fwd.sql -T 20 postgres -Dnitems=100 -Dnlimit=50
transaction type: /home/florisvannee/workspace/pg_dev/limit/test_fwd.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 20 s
number of transactions actually processed: 9465
latency average = 2.113 ms
tps = 473.205818 (including connections establishing)
tps = 473.274649 (excluding connections establishing)
+++ pgbench -n -f /home/florisvannee/workspace/pg_dev/limit/test_fwd.sql -T 20 postgres -Dnitems=1000 -Dnlimit=50
transaction type: /home/florisvannee/workspace/pg_dev/limit/test_fwd.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 20 s
number of transactions actually processed: 1015
latency average = 19.709 ms
tps = 50.738310 (including connections establishing)
tps = 50.745497 (excluding connections establishing)
+++ pgbench -n -f /home/florisvannee/workspace/pg_dev/limit/test_fwd.sql -T 20 postgres -Dnitems=10000 -Dnlimit=50
transaction type: /home/florisvannee/workspace/pg_dev/limit/test_fwd.sql
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
duration: 20 s
number of transactions actually processed: 103
latency average = 194.247 ms
tps = 5.148077 (including connections establishing)
tps = 5.148805 (excluding connections establishing)