Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id D51E72E0035 for ; Thu, 5 Jun 2008 03:54:21 -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 89905-03 for ; Thu, 5 Jun 2008 03:54:13 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail01.enterprisedb.com (webmail.enterprisedb.com [63.246.7.168]) by developer.postgresql.org (Postfix) with ESMTP id 251C22E0030 for ; Thu, 5 Jun 2008 03:54:15 -0300 (ADT) thread-index: AcjG2RKc8qTU5YGERbiL2aZSsvmoMw== Received: from [192.168.1.105] ([82.181.212.226]) by mail01.enterprisedb.com over TLS secured channel with Microsoft SMTPSVC(6.0.3790.3959); Thu, 5 Jun 2008 02:54:59 -0400 Content-Class: urn:content-classes:message Importance: normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.4133 Message-ID: <48478D8F.1030006@enterprisedb.com> Date: Thu, 05 Jun 2008 09:54:07 +0300 From: "Heikki Linnakangas" Organization: EnterpriseDB User-Agent: Mozilla-Thunderbird 2.0.0.12 (X11/20080420) MIME-Version: 1.0 To: Subject: Re: Overhauling GUCS 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> In-Reply-To: Content-Type: text/plain; format=flowed; charset="ISO-8859-1" Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 05 Jun 2008 06:54:59.0546 (UTC) FILETIME=[1230F3A0:01C8C6D9] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200806/220 X-Sequence-Number: 119333 Guys, 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. 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. -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com