On Fri, 27 Apr 2007, Josh Berkus wrote:
*Everyone* wants this. The problem is that it's very hard code to write given the number of variables
There's lots of variables, and there are at least three major ways to work on improving someone's system:
1) Collect up data about their system (memory, disk layout), find out a bit about their apps/workload, and generate a config file based on that.
2) Connect to the database and look around. Study the tables and some their stats, make some estimates based on what your find, produce a new config file.
3) Monitor the database while it's doing its thing. See which parts go well and which go badly by viewing database statistics like pg_statio.
