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 6552C310B40 for ; Wed, 2 Jul 2003 01:24:59 +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 68051-02 for ; Tue, 1 Jul 2003 22:24:49 -0300 (ADT) Received: from houston.familyhealth.com.au (unknown [203.59.48.253]) by svr1.postgresql.org (Postfix) with ESMTP id C139E310705 for ; Tue, 1 Jul 2003 22:24:47 -0300 (ADT) Received: from mars (work-40.internal [192.168.0.40]) by houston.familyhealth.com.au (8.12.9/8.12.9) with SMTP id h621Oaxa084903; Wed, 2 Jul 2003 09:24:38 +0800 (WST) (envelope-from chriskl@familyhealth.com.au) Message-ID: <04b601c3403a$877ef0b0$2800a8c0@mars> From: "Christopher Kings-Lynne" To: , "Hilary Forbes" References: <5.1.0.14.0.20030701125931.02040fa0@mailserver.ipl.co.uk> Subject: Re: Version 7 question Date: Wed, 2 Jul 2003 09:37:19 +0800 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Archive-Number: 200307/22 X-Sequence-Number: 2315 Hi Hillary, I'd suggest around 1000 to 2000 shared buffers and bump your max connections to at least 64. Make sure you're kernel allowed enough shared memory for the above (2000 * 8k = 16MB) Chris ----- Original Message ----- From: "Hilary Forbes" To: Sent: Tuesday, July 01, 2003 8:10 PM 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 >