Re: [HACKERS] Changing the default configuration

Josh Berkus <josh@agliodbs.com>

From: Josh Berkus <josh@agliodbs.com>
To: Tatsuo Ishii <t-ishii@sra.co.jp>, tgl@sss.pgh.pa.us
Cc: justin@postgresql.org, merlin.moncure@rcsonline.com, pgsql-hackers@postgresql.org, pgsql-advocacy@postgresql.org
Date: 2003-02-14T04:00:35Z
Lists: pgsql-hackers, pgsql-performance
Tatsuo,

> Sigh. People always complain "pgbench does not reliably producing
> repeatable numbers" or something then say "that's because pgbench's
> transaction has too much contention on the branches table". So I added
> -N option to pgbench which makes pgbench not to do any UPDATE to
> the branches table. But still people continue to complian...

Hey, pg_bench is a good start on a Postgres performance tester, and it's much, 
much better than what there was before you came along ... which was nothing.  
Thank you again for contributing it.

pg_bench is, however, only  a start on a performance tester, and we'd need to 
build it up before we could use it as the basis of a PG tuner.

-- 
Josh Berkus
Aglio Database Solutions
San Francisco