Re: Overhauling GUCS

On Jun 6, 2008, at 12:22 PM, Greg Smith wrote:

> On Fri, 6 Jun 2008, Peter Eisentraut wrote:
>
>> - What settings do "newbies" (or anyone else) typically need to  
>> change?
>> Please post a list.
>> - What values would you set those settings to?  Please provide a  
>> description
>> for arriving at a value, which can later be transformed into code.   
>> Note that
>> in some cases, not even the documentation provides more than  
>> handwaving help.
>
> Josh's spreadsheet at http://pgfoundry.org/docman/view.php/1000106/84/calcfactors.sxc 
>  provides five different models for setting the most critical  
> parameters based on different types of workloads.  Everyone can  
> quibble over the fine tuning, but having a good starter set of  
> reasonable settings for these parameters is a solved problem.


>  It's just painful to build a tool to apply the available expert  
> knowledge that is already around.

I hope to have something in a week or so that's a first cut at that  
tool. I'm aiming at a GUI tool at first, as I think that's the main  
need, though once the basics are done an interactive or non- 
interactive CLI version shouldn't be a big deal.

Cheers,  Steve