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