port=5432
host=localhost
dbname=postgres

cat <<EOT > setup.sql
drop table if exists j1,j2,j3,j4;
-- Test 1:
create table j1 (very_long_column_name_to_test_json_escape text);
insert into j1 select repeat('x', x) from generate_series(0,1024)x;
vacuum freeze j1;
-- Test 2:
create table j2 (very_long_column_name_to_test_json_escape text);
insert into j2 select repeat('x', 1024*10) from generate_series(0,1024)x;
vacuum freeze j2;
-- Test 3:
create table j3 (very_long_column_name_to_test_json_escape text);
insert into j3 select repeat('x', 1024*1024) from generate_series(0,10)x;
vacuum freeze j3;
-- Test 4:
create table j4 (shrtname text);
insert into j4 select repeat('x', 4) from generate_series(0,1024)x;
vacuum freeze j4;
EOT

psql -f setup.sql -p $port -h $host $dbname

echo "Test 1"
echo "select row_to_json(j1)::jsonb from j1;" > test1.sql
for i in {1..3}; do pgbench -n -f test1.sql -T 10 -M prepared -p $port -h $host $dbname | grep tps; done

echo "Test 2"
echo "select row_to_json(j2)::jsonb from j2;" > test2.sql
for i in {1..3}; do pgbench -n -f test2.sql -T 10 -M prepared -p $port -h $host $dbname | grep tps; done

echo "Test 3"
echo "select row_to_json(j3)::jsonb from j3;" > test3.sql
for i in {1..3}; do pgbench -n -f test3.sql -T 10 -M prepared -p $port -h $host $dbname | grep tps; done

echo "Test 4"
echo "select row_to_json(j4)::jsonb from j4;" > test4.sql
for i in {1..3}; do pgbench -n -f test4.sql -T 10 -M prepared -p $port -h $host $dbname | grep tps; done