Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 9B4A72E0079 for ; Wed, 11 Jun 2008 22:03:06 -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 37870-02-8 for ; Wed, 11 Jun 2008 22:02:36 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from outmail137155.authsmtp.com (outmail137155.authsmtp.com [62.13.137.155]) by developer.postgresql.org (Postfix) with ESMTP id 95CC82E00D1 for ; Wed, 11 Jun 2008 21:38:00 -0300 (ADT) Received: from mail-c188.authsmtp.com (mail-c188.authsmtp.com [62.13.128.25]) by punt6.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id m5C0bjfK074704; Thu, 12 Jun 2008 01:37:45 +0100 (BST) Received: from josh-berkuss-macbook.local (dsl092-188-109.sfo1.dsl.speakeasy.net [66.92.188.109]) (authenticated bits=0) by mail.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id m5C0be7g083853; Thu, 12 Jun 2008 01:37:41 +0100 (BST) Message-ID: <48506FD4.7020804@agliodbs.com> Date: Wed, 11 Jun 2008 17:37:40 -0700 From: Josh Berkus User-Agent: Thunderbird 2.0.0.14 (Macintosh/20080421) MIME-Version: 1.0 To: Gregory Stark CC: Tom Lane , Alvaro Herrera , Heikki Linnakangas , pgsql-hackers@postgresql.org, Robert Treat , Peter Eisentraut , Greg Smith , Andreas Pflug , "Decibel!" Subject: Re: Overhauling GUCS References: <48409D1E.3070208@agliodbs.com> <200806061624.29105.xzilla@users.sourceforge.net> <200806100937.38124.josh@agliodbs.com> <200806100949.17918.josh@agliodbs.com> <21875.1213122184@sss.pgh.pa.us> <484F7613.5070202@enterprisedb.com> <484FFF06.9010307@agliodbs.com> <20080611163847.GN5352@alvh.no-ip.org> <11913.1213218315@sss.pgh.pa.us> <87od674hy6.fsf@oxford.xeocode.com> In-Reply-To: <87od674hy6.fsf@oxford.xeocode.com> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Server-Quench: c5ed0bba-3817-11dd-aecc-001871e930f4 X-AuthRoute: OCdyZgscClZXSx8a IioLCC5HRQ8+YBZL BAkGMA9GIUINWEQI agdMdwAUEkAaAgsB A24bW1VeU1p7XWc7 bQxPZAdDY0JGQQRq WVdLR1BXCwUmXBly BkxLVU5yfwZOfX0+ ZEBjVj4IWREudRQv E1NXHWwBeGZhPDQC ARULJB5UcAJCeR4Q Y1N/AndDAzANdgUm EhUzNi01PDNQYAto aTpl X-Authentic-SMTP: 61633136333939.cat.dmpriest.net.uk:1045/Kp X-Report-SPAM: If SPAM / abuse - report it at: http://www.authsmtp.com/abuse X-Virus-Status: No virus detected - but ensure you scan with your own anti-virus system! X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200806/534 X-Sequence-Number: 119647 Greg, > At least that way we could always steal more if we want or return some, as > long as we're careful about when we do it. That would open the door to having > these parameters be dynamically adjustable. That alone would be worthwhile > even if we bypass all bells and whistles of the buffer manager. > One hitch, though, is that asynchronous commit could consume big chunks of shared_buffers. So we might still need a limit for people who are using async. --Josh