Automatic tuning of postgresql.conf parameters? - Mailing list pgsql-performance

From Mattias Kregert
Subject Automatic tuning of postgresql.conf parameters?
Date
Msg-id 00b201c653da$a4409670$09000a0a@kregert.se
Whole thread Raw
List pgsql-performance
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:

Previous
From: Michael Stone
Date:
Subject: Re: Index scan startup time
Next
From: Tom Lane
Date:
Subject: Re: Index scan startup time