Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id C4DEF2E0039 for ; Thu, 5 Jun 2008 05:16:04 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 69653-05 for ; Thu, 5 Jun 2008 05:15:51 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from westnet.com (westnet.com [216.187.52.2]) by developer.postgresql.org (Postfix) with ESMTP id CF8DB2E0038 for ; Thu, 5 Jun 2008 05:15:52 -0300 (ADT) Received: from westnet.com (localhost [127.0.0.1]) by westnet.com (8.14.0/8.14.0) with ESMTP id m558Fo6o014751; Thu, 5 Jun 2008 04:15:50 -0400 (EDT) Received: from localhost (gsmith@localhost) by westnet.com (8.14.0/8.13.2/Submit) with ESMTP id m558Fnmm014747; Thu, 5 Jun 2008 04:15:49 -0400 (EDT) X-Authentication-Warning: westnet.com: gsmith owned process doing -bs Date: Thu, 5 Jun 2008 04:15:49 -0400 (EDT) From: Greg Smith X-X-Sender: gsmith@westnet.com To: Heikki Linnakangas cc: pgsql-hackers@postgresql.org Subject: Re: Overhauling GUCS In-Reply-To: <48478D8F.1030006@enterprisedb.com> Message-ID: References: <17932.1212415926@sss.pgh.pa.us> <20080604131810.GH65238@decibel.org> <4846A483.8000001@pse-consulting.de> <29525.1212613052@sss.pgh.pa.us> <48472E47.7030701@dunslane.net> <7473.1212625397@sss.pgh.pa.us> <20080605011455.GF14498@yugib.highrise.ca> <20080605023720.GG14498@yugib.highrise.ca> <48478D8F.1030006@enterprisedb.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200806/223 X-Sequence-Number: 119336 On Thu, 5 Jun 2008, Heikki Linnakangas wrote: > A configuration wizard would be nice, but it would be a good start to add a > section to the manual on how to do the basic tuning. AFAICS we don't have > one. Clear instructions on how to set the few most important settings like > shared_buffers and checkpoint_timeout/segments would probably be enough, with > a link to the main configuration section that explains the rest of the > settings. It hasn't gelled yet but I'm working on that. Most of the text needed is now linked to at http://wiki.postgresql.org/wiki/Performance_Optimization I already talked with Chris Browne about merging his document I put first in that list with useful pieces from some of mine into one more comprehensive document on the Wiki, covering everything you mention here. If we took a snapshot of that when it's done and dumped that into the manual, I don't think that would be a problem to wrap up before 8.4 is done. I'd like to include a link to the above performance page in that section of the manual as well, both so that people are more likely to find fresh content as well as to give them pointers toward more resources than the manual can possibly cover. > If people don't read the manual, we can add a link to it from > postgresql.conf.sample, add a screen to the Windows installer suggesting > to read it, or even open postgresql.conf in Notepad. They don't. Putting pointers toward a relatively simple performance tuning document a bit more in people's faces might help lower some of the criticism the project takes over providing low defaults for so many things. -- * Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD