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

atri's hintbit 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: 581
tps = 1.922088 (including connections establishing)
tps = 1.922219 (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: 1218
tps = 4.044082 (including connections establishing)
tps = 4.044356 (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: 19372703
tps = 64550.118693 (including connections establishing)
tps = 64553.122532 (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: 19417975
tps = 64708.410408 (including connections establishing)
tps = 64711.467193 (excluding connections establishing)
================================================
hintbit 
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: 1923
tps = 6.388550 (including connections establishing)
tps = 6.388951 (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: 1920
tps = 6.378066 (including connections establishing)
tps = 6.378522 (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: 1920
tps = 6.378186 (including connections establishing)
tps = 6.378570 (excluding connections establishing)
================================================
hintbit 
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: 416
tps = 1.364586 (including connections establishing)
tps = 1.364654 (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.359852 (including connections establishing)
tps = 1.359910 (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.362394 (including connections establishing)
tps = 1.362456 (excluding connections establishing)
================================================
hintbit 
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: 1920
tps = 6.378497 (including connections establishing)
tps = 6.378823 (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: 1920
tps = 6.380956 (including connections establishing)
tps = 6.381375 (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: 1920
tps = 6.379452 (including connections establishing)
tps = 6.379846 (excluding connections establishing)
================================================
hintbit
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.361466 (including connections establishing)
tps = 1.361546 (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.360528 (including connections establishing)
tps = 1.360616 (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.362344 (including connections establishing)
tps = 1.362421 (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: 177.152 ms
postgres=# vacuum atri1;
VACUUM
Time: 179.139 ms
postgres=# drop table atri1;
DROP TABLE
Time: 34.014 ms
postgres=# create  table atri1 as select v from generate_series(1,1000000) v;
SELECT 1000000
Time: 1407.942 ms
postgres=# select count(*) from atri1;
  count
---------
 1000000
(1 row)

Time: 176.952 ms
postgres=# vacuum atri1;
VACUUM
Time: 183.348 ms
postgres=# drop table atri1;
DROP TABLE
Time: 33.152 ms
postgres=# create  table atri1 as select v from generate_series(1,1000000) v;
SELECT 1000000
Time: 1452.167 ms
postgres=#  select count(*) from atri1;
  count
---------
 1000000
(1 row)

Time: 177.067 ms
postgres=# vacuum atri1;
VACUUM
Time: 181.389 ms
postgres=#  drop table atri1;
DROP TABLE
