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 0D7A430F536 for ; Tue, 1 Jul 2003 12:17:16 +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 51636-05 for ; Tue, 1 Jul 2003 09:17:05 -0300 (ADT) Received: from mwinf0202.wanadoo.fr (smtp7.wanadoo.fr [193.252.22.29]) by svr1.postgresql.org (Postfix) with ESMTP id 44D8530F452 for ; Tue, 1 Jul 2003 09:17:05 -0300 (ADT) Received: from Paris (ABoulogne-110-1-3-43.w80-15.abo.wanadoo.fr [80.15.41.43]) by mwinf0202.wanadoo.fr (SMTP Server) with ESMTP id 64FCDA400116; Tue, 1 Jul 2003 14:17:04 +0200 (CEST) Reply-To: From: "Michael Mattox" To: "Hilary Forbes" , Subject: Re: Version 7 question Date: Tue, 1 Jul 2003 14:17:08 +0200 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0) In-Reply-To: <5.1.0.14.0.20030701125931.02040fa0@mailserver.ipl.co.uk> Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Archive-Number: 200307/7 X-Sequence-Number: 2300 I have my shared buffers at 8192 and my effective cache at 64000 (which is 500 megs). Depends a lot on how much RAM you have. I have 1.5 gigs and I've been asking my boss for another 512megs for over a month now. I have no idea if my buffers are too high/low. Michael > -----Original Message----- > From: pgsql-performance-owner@postgresql.org > [mailto:pgsql-performance-owner@postgresql.org]On Behalf Of Hilary > Forbes > Sent: Tuesday, July 01, 2003 2:10 PM > To: pgsql-performance@postgresql.org > Subject: [PERFORM] Version 7 question > > > 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? Also is there an equivalent of > effective_cache_size that I can set for version 7? > > Many thanks in advance > Hilary > > > > > Hilary Forbes > ------------- > DMR Computer Limited: http://www.dmr.co.uk/ > Direct line: 01689 889950 > Switchboard: (44) 1689 860000 Fax: (44) 1689 860330 > E-mail: hforbes@dmr.co.uk > > ********************************************************** > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faqs/FAQ.html >