+++++ dirname ./test_limit.sh
++++ cd .
++++ pwd
+++ DIR=/home/florisvannee/workspace/pg_dev/limit
+++ T=20
+++ /home/florisvannee/workspace/pg_dev/start.sh master
++++ [[ 1 -eq 2 ]]
++++ [[ 1 -eq 1 ]]
++++ bdir=/home/florisvannee/workspace/postgres
++++ totaldir=master-release
++++ cd /home/florisvannee/workspace/postgres
++++ /home/florisvannee/install/master-release/bin/pg_ctl -D/home/florisvannee/pgdata/master-release -l /home/florisvannee/pgdata/master-release/logfile -t 5 stop
pg_ctl: could not send stop signal (PID: 29950): No such process
++++ pkill -9 postgres
++++ /home/florisvannee/install/master-release/bin/pg_ctl -D/home/florisvannee/pgdata/master-release -l /home/florisvannee/pgdata/master-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: 154896
latency average = 0.129 ms
tps = 7744.777852 (including connections establishing)
tps = 7745.481275 (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: 130189
latency average = 0.154 ms
tps = 6509.413300 (including connections establishing)
tps = 6510.194847 (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: 51467
latency average = 0.389 ms
tps = 2573.330950 (including connections establishing)
tps = 2573.706453 (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: 7820
latency average = 2.558 ms
tps = 390.956588 (including connections establishing)
tps = 391.013884 (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: 219722
latency average = 0.091 ms
tps = 10986.053856 (including connections establishing)
tps = 10987.598953 (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: 215711
latency average = 0.093 ms
tps = 10785.486753 (including connections establishing)
tps = 10786.586186 (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: 174473
latency average = 0.115 ms
tps = 8723.607124 (including connections establishing)
tps = 8724.854159 (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: 93067
latency average = 0.215 ms
tps = 4653.322050 (including connections establishing)
tps = 4654.022097 (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: 23328
latency average = 0.857 ms
tps = 1166.383516 (including connections establishing)
tps = 1166.560584 (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: 2823
latency average = 7.086 ms
tps = 141.115678 (including connections establishing)
tps = 141.135409 (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: 292
latency average = 68.710 ms
tps = 14.553922 (including connections establishing)
tps = 14.555983 (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: 90974
latency average = 0.220 ms
tps = 4548.655001 (including connections establishing)
tps = 4549.337781 (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: 22080
latency average = 0.906 ms
tps = 1103.982784 (including connections establishing)
tps = 1104.122082 (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: 2630
latency average = 7.606 ms
tps = 131.467656 (including connections establishing)
tps = 131.486783 (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: 271
latency average = 73.890 ms
tps = 13.533643 (including connections establishing)
tps = 13.535616 (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: 56385
latency average = 0.355 ms
tps = 2819.202652 (including connections establishing)
tps = 2819.611918 (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: 9744
latency average = 2.053 ms
tps = 487.182328 (including connections establishing)
tps = 487.247681 (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: 1050
latency average = 19.059 ms
tps = 52.469680 (including connections establishing)
tps = 52.477479 (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: 107
latency average = 187.881 ms
tps = 5.322504 (including connections establishing)
tps = 5.323249 (excluding connections establishing)