X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.193]) by svr1.postgresql.org (Postfix) with ESMTP id C97C030FF25 for ; Tue, 1 Jul 2003 12:53:00 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr1.postgresql.org [64.117.224.193]) (amavisd-new, port 10024) with ESMTP id 56227-04 for ; Tue, 1 Jul 2003 09:52:50 -0300 (ADT) Received: from localhost.localdomain (unknown [65.217.53.66]) by svr1.postgresql.org (Postfix) with ESMTP id AC6D63106B8 for ; Tue, 1 Jul 2003 09:52:49 -0300 (ADT) Received: from thorn.mmrd.com (thorn.mmrd.com [172.25.10.100]) by localhost.localdomain (8.12.8/8.12.8) with ESMTP id h61DoO4i016885; Tue, 1 Jul 2003 09:50:24 -0400 Received: from gnvex001.mmrd.com (gnvex001.mmrd.com [192.168.3.55]) by thorn.mmrd.com (8.11.6/8.11.6) with ESMTP id h61CqRZ13981; Tue, 1 Jul 2003 08:52:27 -0400 Received: from camel.mmrd.com ([172.25.5.213]) by gnvex001.mmrd.com with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2653.13) id MTKBPTNK; Tue, 1 Jul 2003 08:52:25 -0400 Subject: Re: Version 7 question From: Robert Treat To: Hilary Forbes Cc: pgsql-performance@postgresql.org In-Reply-To: <5.1.0.14.0.20030701125931.02040fa0@mailserver.ipl.co.uk> References: <5.1.0.14.0.20030701125931.02040fa0@mailserver.ipl.co.uk> Content-Type: text/plain Content-Transfer-Encoding: 7bit X-Mailer: Ximian Evolution 1.0.8 Date: 01 Jul 2003 08:52:26 -0400 Message-Id: <1057063946.24304.377.camel@camel> Mime-Version: 1.0 X-Archive-Number: 200307/8 X-Sequence-Number: 2301 On Tue, 2003-07-01 at 08:10, Hilary Forbes wrote: > I'm just trying to improve performance on version 7 before doing some tests and hopefully upgrading to 7.3. > > At the moment we have > B=64 (no of shared buffers) > N=32 (no of connections) > in postmaster.opt which I take it is the equivalent of the new postgresql.conf file. > > From all that is being written about later versions I suspect that >this is far too low. Would I be fairly safe in making the no of shared >buffers larger? yes, I'd say start with about 25% of RAM, then adjust from there. If 25% takes you over your SHMMAX then start at your SHMMAX. >Also is there an equivalent of effective_cache_size that I can set for >version 7? > If by 7 your mean 7.0.x then I don't believe so, been awhile though, I could be wrong. IMHO no amount of tuning you can do in 7.0 would be as effective as an upgrade, after setting your shared buffers up, I'd put your efforts into upgrading. (Note Beta test for 7.4 starts in 2 weeks) Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL