|
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)
|
