Re: Overhauling GUCS

On Aug 17, 2008, at 1:48 PM, Greg Smith wrote:

> On Wed, 13 Aug 2008, Michael Nacos wrote:
>
>> Hi there... Configuration autotuning is something I am really  
>> interested in.
>> I have seen this page: http://wiki.postgresql.org/wiki/ 
>> GUCS_Overhaul and
>> a couple of emails mentioning this, so I wanted to ask is someone  
>> already
>> on it? If yes, I'd like to contribute.
>
> Good time to give a status report on what's been going on with all  
> this.
>
> With some help I just finished off an answer to problem #1 there  
> recently, "Most people have no idea how to set these".  There was  
> some concern here that work was being done on config tools without a  
> clear vision of what was going to be tuned.  See http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server 
>  for an intro on how to set the 18 most important parameters (+7  
> logging parameters) based on the best information I'm aware of.
>
> Circa June, Steve Atkins was looking into writing a C++/Qt GUI  
> tuning interface application, with the idea that somebody else would  
> figure out the actual smarts to the tuning effort.  Don't know where  
> that's at.

First pass is done. Needs a little cleanup before sharing. I spent a  
fair while down OS-specific-hardware-queries rathole, but I'm better  
now.

Cheers,  Steve