X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id F342AD1B500 for ; Tue, 16 Sep 2003 08:31:32 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 29468-10 for ; Tue, 16 Sep 2003 05:31:03 -0300 (ADT) Received: from wight.ymogen.net (unknown [217.27.240.153]) by svr1.postgresql.org (Postfix) with SMTP id 3165FD1B4F2 for ; Tue, 16 Sep 2003 05:31:00 -0300 (ADT) Received: (qmail 11531 invoked from network); 16 Sep 2003 08:31:01 -0000 Received: from dsl-217-155-239-51.zen.co.uk (HELO finisterre) (217.155.239.51) by wight.ymogen.net with SMTP; 16 Sep 2003 08:31:01 -0000 From: "Matt Clark" To: "Joseph Bove" , Subject: Re: Inconsistent performance Date: Tue, 16 Sep 2003 09:31:01 +0100 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.2910.0) X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 In-reply-to: <5.1.0.14.2.20030915191708.00a6a0d8@mail.vetstar.com> Importance: Normal X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/234 X-Sequence-Number: 3600 ... > #effective_cache_size = 1000 # typically 8KB each That's horribly wrong. It's telling PG that your OS is only likely to cache 8MB of the DB in RAM. If you've got 1GB of memory it should be between 64000 and 96000