Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 352952E0086 for ; Thu, 5 Jun 2008 16:53:57 -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 74335-10 for ; Thu, 5 Jun 2008 16:53:51 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from smtp108.biz.mail.mud.yahoo.com (smtp108.biz.mail.mud.yahoo.com [68.142.201.177]) by developer.postgresql.org (Postfix) with SMTP id 13CB42E0046 for ; Thu, 5 Jun 2008 16:53:53 -0300 (ADT) Received: (qmail 38612 invoked from network); 5 Jun 2008 19:53:52 -0000 Received: from unknown (HELO ?192.168.5.105?) (ramayer@forensiclogic.com@76.202.62.108 with plain) by smtp108.biz.mail.mud.yahoo.com with SMTP; 5 Jun 2008 19:53:52 -0000 X-YMail-OSG: uiE3C1oVM1nS6C9wDpuSo9hYPmIbH_8jrfKGNSBKvqOPgBCFBYx5k..dO9JQSAixkGFNPp6kwOAOpQNB_aaIgS1GNpEQz2P4oRtgujEaZov0q5x2BnSiMHG46FWjU6OFHKg- X-Yahoo-Newman-Property: ymail-3 Message-ID: <48484453.7030105@cheapcomplexdevices.com> Date: Thu, 05 Jun 2008 12:53:55 -0700 From: Ron Mayer User-Agent: Mozilla-Thunderbird 2.0.0.14 (X11/20080509) MIME-Version: 1.0 CC: PostgreSQL Developers Subject: Re: Overhauling GUCS References: <48409D1E.3070208@agliodbs.com> <200806010032.53337.peter_e@gmx.net> <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> <448BD875-FE20-4985-92CD-DFF6FC0641D3@blighty.com> In-Reply-To: <448BD875-FE20-4985-92CD-DFF6FC0641D3@blighty.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.166 tagged_above=0 required=5 tests=AWL=-1.415, MISSING_HEADERS=1.581 X-Spam-Level: X-Archive-Number: 200806/255 X-Sequence-Number: 119368 Steve Atkins wrote: > ... cross-platform (Windows, Linux, Solaris, OS X as a bare > minimum) I wonder how cross-platform the tuning algorithm itself is. I could also imagine that decisions like "do I let the OS page cache, or postgres's buffer cache get most of the memory" are extremely OS dependent. Also, the configuration tool would be even more useful if it could offer extra platform-specific advice like "hey, I see you're using this filesystem. You should be using this journaling option for WAL and this other one for data", or "on your system you should be using this fsync method", or "use relatime or noatime when mounting your disk".