On Thu, Dec 6, 2012 at 8:52 PM, Merlin Moncure <mmoncure@gmail.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.