X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 2BD8FD1B514 for ; Sat, 24 Apr 2004 12:38:36 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 40774-04 for ; Sat, 24 Apr 2004 12:38:34 -0300 (ADT) Received: from davinci.ethosmedia.com (server228.ethosmedia.com [209.128.84.228]) by svr1.postgresql.org (Postfix) with ESMTP id 52D0DD1B4F7 for ; Sat, 24 Apr 2004 12:38:33 -0300 (ADT) Received: from [63.195.55.98] (HELO spooky) by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.1.8) with ESMTP id 4937428; Sat, 24 Apr 2004 08:39:58 -0700 Content-Type: text/plain; charset="iso-8859-1" From: Josh Berkus Organization: Aglio Database Solutions To: Tom Lane , Ron Mayer Subject: Re: Setting Shared Buffers , Effective Cache, Sort Mem Date: Sat, 24 Apr 2004 08:37:42 -0700 User-Agent: KMail/1.4.3 Cc: Manfred Koizar , Pallav Kalva , pgsql-performance@postgresql.org References: <4088062E.2050901@deg.cc> <6798.1082775014@sss.pgh.pa.us> In-Reply-To: <6798.1082775014@sss.pgh.pa.us> MIME-Version: 1.0 Content-Transfer-Encoding: 8bit Message-Id: <200404240837.42398.josh@agliodbs.com> X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200404/426 X-Sequence-Number: 6726 Tom, > It's possible that Jan's recent buffer-management improvements will > change the story as of 7.5. I kinda doubt it myself, but it'd be worth > re-running any experiments you've done when you start working with 7.5. Yes, Jan has indicated to me that he expects to make much heavier use of shared buffers under ARC. But 7.5 still seems to be too unstable for me to test this assertion on a large database. -- Josh Berkus Aglio Database Solutions San Francisco