X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 2BEAA5E4710 for ; Tue, 31 Aug 2004 17:31:40 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 51998-10 for ; Tue, 31 Aug 2004 20:31:34 +0000 (GMT) Received: from server.gpdnet.co.uk (gpdnet.plus.com [212.56.100.243]) by svr1.postgresql.org (Postfix) with ESMTP id CDA4A5E470C for ; Tue, 31 Aug 2004 17:31:33 -0300 (ADT) Received: from gary (unknown [192.168.1.2]) by server.gpdnet.co.uk (Postfix) with ESMTP id 3910FFBEA6 for ; Tue, 31 Aug 2004 21:31:41 +0100 (BST) From: "Gary Doades" To: pgsql-performance@postgresql.org Date: Tue, 31 Aug 2004 21:31:44 +0100 MIME-Version: 1.0 Subject: Re: Optimizing a request Message-ID: <4134EE40.24471.4EF6928@localhost> In-reply-to: <4b09a0c04083113243b6198b8@mail.gmail.com> References: <4134EABE.28891.4E1B76A@localhost> X-mailer: Pegasus Mail for Windows (v4.12a) Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7BIT Content-description: Mail message body X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200408/486 X-Sequence-Number: 8122 On 31 Aug 2004 at 22:24, Jean-Max Reymond wrote: > On Tue, 31 Aug 2004 21:16:46 +0100, Gary Doades wrote: > > > I can only presume you mean 1 GB RAM. What exactly are your > > settings for shared buffers and effective_cache_size? > > for 1 GB RAM, > shared_buffers = 65536 > effective_cache_size = 16384 This seems like the wrong way round also. You might try: shared_buffers = 10000 effective_cache_size = 60000 Cheers, Gary.