I have noticed that a lot of people have a hard time finding out how to tune postgresql to suit their hardware.
Are there any tools for automatic tuning of the parameters in postgresql.conf? A simple program running some benchmarks on cpu & disk speed, checking the amount of ram and so on and then suggesting random/seq access cost, vacuum cust, sortmem/cache settings and so on? A pg_tune utility?
Maybe it could even look at runtime statistics/usage logs and help set the number of shared buffers, chekpoints, autovacuum...?
/Mattias (using the default config)
pgsql-performance by date
|Next:||From: Peter Eisentraut||Date: 2006-03-30 11:59:10|
|Subject: Index scan startup time|
|Previous:||From: Markus Schaber||Date: 2006-03-30 08:29:51|
|Subject: Re: Decide between Postgresql and Mysql (help of|