Re: [HACKERS] [GENERAL] New PostgreSQL Tool available :pg_autotune

2002-09-25 Thread Justin Clift
Tatsuo Ishii wrote: > > > You should have chosen a better foundation. pg_bench is notorious for > > producing results that are (a) nonrepeatable and (b) not relevant to > > a wide variety of situations. All it really tells you about is the > > efficiency of a large number of updates to a small

Re: [HACKERS] [GENERAL] New PostgreSQL Tool available : pg_autotune

2002-09-22 Thread Justin Clift
Tom Lane wrote: > > Justin Clift <[EMAIL PROTECTED]> writes: > > Have been putting together a tool called "pg_autotune" for automatically > > tuning a PostgreSQL database (either local or remote). It does this by > > repetitively benchmarking PostgreSQL (using Tatsuo's pgbench code) with > > dif

Re: [HACKERS] [GENERAL] New PostgreSQL Tool available : pg_autotune

2002-09-22 Thread Tom Lane
Justin Clift <[EMAIL PROTECTED]> writes: > Have been putting together a tool called "pg_autotune" for automatically > tuning a PostgreSQL database (either local or remote). It does this by > repetitively benchmarking PostgreSQL (using Tatsuo's pgbench code) with > different buffer settings, then