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
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
