X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id F08F0D1B482 for ; Sun, 14 Dec 2003 05:42:38 +0000 (GMT) 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 79311-06 for ; Sun, 14 Dec 2003 01:42:22 -0400 (AST) Received: from candle.pha.pa.us (candle.pha.pa.us [207.106.42.251]) by svr1.postgresql.org (Postfix) with ESMTP id 63E3AD1B442 for ; Sun, 14 Dec 2003 01:42:09 -0400 (AST) Received: (from pgman@localhost) by candle.pha.pa.us (8.11.6/8.11.6) id hBE5gLI21410; Sun, 14 Dec 2003 00:42:21 -0500 (EST) From: Bruce Momjian Message-Id: <200312140542.hBE5gLI21410@candle.pha.pa.us> Subject: Re: Tuning for mid-size server In-Reply-To: <20031021213408.GA12200@libertyrms.info> To: Andrew Sullivan Date: Sun, 14 Dec 2003 00:42:21 -0500 (EST) Cc: pgsql-performance@postgresql.org X-Mailer: ELM [version 2.4ME+ PL108 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200312/215 X-Sequence-Number: 5075 Andrew Sullivan wrote: > On Tue, Oct 21, 2003 at 03:11:17PM -0600, scott.marlowe wrote: > > I think where it makes sense is when you have something like a report > > server where the result sets may be huge, but the parellel load is load, > > i.e. 5 or 10 users tossing around 100 Meg or more at time. > > In our case, we were noticing that truss showed an unbelievable > amount of time spent by the postmaster doing open() calls to the OS > (this was on Solaris 7). So we thought, "Let's try a 2G buffer > size." 2G was more than enough to hold the entire data set under > question. Once the buffer started to fill, even plain SELECTs > started taking a long time. The buffer algorithm is just not that > clever, was my conclusion. > > (Standard disclaimer: not a long, controlled test. It's just a bit > of gossip.) I know this is an old email, but have you tested larger shared buffers in CVS HEAD with Jan's new cache replacement policy? -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073