On Thu, Dec 6, 2012 at 8:52 PM, Merlin Moncure <mmonc...@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. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers