Re: Overhauling GUCS

Added to TODO:
       o Add external tool to auto-tune some postgresql.conf parameters
        http://archives.postgresql.org/pgsql-hackers/2008-06/msg00000.php


---------------------------------------------------------------------------

Tom Lane wrote:
> Andrew Dunstan <andrew@dunslane.net> writes:
> > Tom Lane wrote:
> >> * Can we build a "configuration wizard" to tell newbies what settings
> >> they need to tweak?
> 
> > That would trump all the other suggestions conclusively. Anyone good at 
> > expert systems?
> 
> How far could we get with the answers to just three questions:
> 
> * How many concurrent queries do you expect to have?
> 
> * How much RAM space are you willing to let Postgres use?
> 
> * How much "overhead" disk space are you willing to let Postgres use?
> 
> concurrent queries drives max_connections, obviously, and RAM space
> would drive shared_buffers and effective_cache_size, and both of them
> would be needed to size work_mem.  The third one is a bit weird but
> I don't see any other good way to set the checkpoint parameters.
> 
> If those aren't enough questions, what else must we ask?  Or maybe they
> aren't the right questions at all --- maybe we should ask "is this a
> dedicated machine or not" and try to extrapolate everything else from
> what we (hopefully) can find out about the hardware.
> 
>             regards, tom lane
> 
> -- 
> Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + If your life is a hard drive, Christ can be your backup. +