PostgreSQL Performance - Automatic tuning of postgresql.conf parameters?

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Automatic tuning of postgresql.conf parameters?

Mattias Kregert

2006-03-30, 9:34 am

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)

Sponsored Links