Note: Autovacuum off for all the testcases.
================================================

atri's original benchmark suite.
./pgbench -f bench_test_atri.sql  -T 300 -n -c 8 postgres
================================================
transaction type: Custom query
scaling factor: 1
query mode: simple
number of clients: 8
number of threads: 1
duration: 300 s
number of transactions actually processed: 535
tps = 1.762825 (including connections establishing)
tps = 1.762946 (excluding connections establishing)
================================================
create table and execute pgbench
create  table atri1 as select v from generate_series(1,1000000) v;
./pgbench -f bench_select_atri.sql  -T 300 -n -c 8 postgres
================================================
transaction type: Custom query
scaling factor: 1
query mode: simple
number of clients: 8
number of threads: 1
duration: 300 s
number of transactions actually processed: 1214
tps = 4.038395 (including connections establishing)
tps = 4.038673 (excluding connections establishing)
================================================

Pgbench with 8 client 8 threads scale factor 75 shared_buffers 500MB checkpoint_segments=256
./pgbench -i -s 75 -n  postgres
./pgbench -T 300 -j 8 -c 8 -n -S  postgres
================================================
transaction type: SELECT only
scaling factor: 75
query mode: simple
number of clients: 8
number of threads: 8
duration: 300 s
number of transactions actually processed: 19501221
tps = 64976.787546 (including connections establishing)
tps = 64980.736149 (excluding connections establishing
================================================

Pgbench unlogged tables with 8 client 8 threads scale factor 75 shared_buffers 500MB
./pgbench -i -s 75 -n --unlogged-tables  postgres
./pgbench -T 300 -j 8 -c 8 -n -S  postgres
================================================
transaction type: SELECT only
scaling factor: 75
query mode: simple
number of clients: 8
number of threads: 8
duration: 300 s
number of transactions actually processed: 19472463
tps = 64871.642936 (including connections establishing)
tps = 64874.974334 (excluding connections establishing)
================================================
original 
test case 1 (Multiple bulk inserts: Select performance- sequential scan)
r1================================================
transaction type: Custom query
scaling factor: 1
query mode: simple
number of clients: 8
number of threads: 8
duration: 300 s
number of transactions actually processed: 1955
tps = 6.491588 (including connections establishing)
tps = 6.491902 (excluding connections establishing)
r2================================================
transaction type: Custom query
scaling factor: 1
query mode: simple
number of clients: 8
number of threads: 8
duration: 300 s
number of transactions actually processed: 1956
tps = 6.494294 (including connections establishing)
tps = 6.494614 (excluding connections establishing)
r3================================================
transaction type: Custom query
scaling factor: 1
query mode: simple
number of clients: 8
number of threads: 8
duration: 300 s
number of transactions actually processed: 1955
tps = 6.491104 (including connections establishing)
tps = 6.491523 (excluding connections establishing)
================================================
original 
test case 2 (Multiple bulk inserts: Select performance- index scan)
r1================================================
transaction type: Custom query
scaling factor: 1
query mode: simple
number of clients: 8
number of threads: 8
duration: 300 s
number of transactions actually processed: 424
tps = 1.390064 (including connections establishing)
tps = 1.390146 (excluding connections establishing)
r2================================================
transaction type: Custom query
scaling factor: 1
query mode: simple
number of clients: 8
number of threads: 8
duration: 300 s
number of transactions actually processed: 424
tps = 1.386596 (including connections establishing)
tps = 1.386691 (excluding connections establishing)
r3================================================
transaction type: Custom query
scaling factor: 1
query mode: simple
number of clients: 8
number of threads: 8
duration: 300 s
number of transactions actually processed: 416
tps = 1.383628 (including connections establishing)
tps = 1.383715 (excluding connections establishing)
================================================
original 
test case 3  (Single bulk inserts: Select performance - sequential scan)
r1================================================
transaction type: Custom query
scaling factor: 1
query mode: simple
number of clients: 8
number of threads: 8
duration: 300 s
number of transactions actually processed: 1952
tps = 6.496914 (including connections establishing)
tps = 6.497186 (excluding connections establishing)
r2================================================
transaction type: Custom query
scaling factor: 1
query mode: simple
number of clients: 8
number of threads: 8
duration: 300 s
number of transactions actually processed: 1955
tps = 6.490791 (including connections establishing)
tps = 6.491052 (excluding connections establishing)
r3================================================
transaction type: Custom query
scaling factor: 1
query mode: simple
number of clients: 8
number of threads: 8
duration: 300 s
number of transactions actually processed: 1955
tps = 6.491045 (including connections establishing)
tps = 6.491332 (excluding connections establishing)

================================================
original 
test case 4  (Single bulk inserts: Select performance - index scan)
r1================================================
transaction type: Custom query
scaling factor: 1
query mode: simple
number of clients: 8
number of threads: 8
duration: 300 s
number of transactions actually processed: 416
tps = 1.386033 (including connections establishing)
tps = 1.386112 (excluding connections establishing)
r2================================================
transaction type: Custom query
scaling factor: 1
query mode: simple
number of clients: 8
number of threads: 8
duration: 300 s
number of transactions actually processed: 416
tps = 1.385193 (including connections establishing)
tps = 1.385268 (excluding connections establishing)
r3================================================
transaction type: Custom query
scaling factor: 1
query mode: simple
number of clients: 8
number of threads: 8
duration: 300 s
number of transactions actually processed: 416
tps = 1.380904 (including connections establishing)
tps = 1.380982 (excluding connections establishing)
================================================

test case - 5 (Long transaction open then Vacuum & select performance.)
================================================
postgres=# create  table atri1 as select v from generate_series(1,1000000) v;
SELECT 1000000
postgres=# \timing
Timing is on.
postgres=# select count(*) from atri1;
  count
---------
 1000000
(1 row)

Time: 218.065 ms
postgres=# vacuum atri1;
VACUUM
Time: 129.919 ms
postgres=# drop table atri1;
DROP TABLE
Time: 36.993 ms
postgres=# create  table atri1 as select v from generate_series(1,1000000) v;
SELECT 1000000
Time: 1453.145 ms
postgres=#  select count(*) from atri1;
  count
---------
 1000000
(1 row)

Time: 197.212 ms
postgres=# vacuum atri1;
VACUUM
Time: 128.128 ms
postgres=# drop table atri1;
DROP TABLE
Time: 29.392 ms
postgres=# create  table atri1 as select v from generate_series(1,1000000) v;
SELECT 1000000
Time: 1433.794 ms
postgres=# select count(*) from atri1;
  count
---------
 1000000
(1 row)

Time: 227.044 ms
postgres=#  vacuum atri1;
VACUUM
Time: 126.860 ms
postgres=#  drop table atri1;
DROP TABLE
