Re: WIP patch for hint bit i/o mitigation

On Thu, Dec 6, 2012 at 8:52 PM, Merlin Moncure <mmoncure(at)gmail(dot)com> wrote:
>Thanks for that -- that's fairly comprehensive I'd say. I'm quite
>interested in that benchmarking framework as well. Do you need help
>setting up the scripts?

Presently I am testing with pgbench custom query option & taking IO & VM
statistics in parallel.

Following way I had written the test script for case -1.

./psql -f bench_test_1_init.sql postgres
iostat -t 1 -d > hint.test1.iostat.reading_3.txt &
vmstat -n 1 > hint.test1.vmstat.reading_3.txt &
./pgbench -f bench_test_1.sql -T 300 -c 8 -j 8 -n postgres
killall -s SIGINT iostat
killall -s SIGINT vmstat

Where the sql files are as follows:

-- bench_test_1.sql
select count(*) from bench where f1 is not null;

--bench_test_1_init.sql

drop table if exists bench;
create table bench(f0 int primary key, f1 char(50));
insert into bench values (generate_series(1, 100000), 'a');
insert into bench values (generate_series(100001, 200000), 'a');
...
insert into bench values (generate_series(9800001, 9900000), 'a');
insert into bench values (generate_series(9900001, 10000000), 'a');
checkpoint;

I will provide the test results later.

Any suggestions/comments?

Regards,
Hari babu.