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 614B65372F for ; Thu, 21 Apr 2005 09:33:28 -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 65143-01 for ; Thu, 21 Apr 2005 12:33:23 +0000 (GMT) Received: from linuxworld.com.au (unknown [203.34.46.50]) by svr1.postgresql.org (Postfix) with ESMTP id 70B1753678 for ; Thu, 21 Apr 2005 09:33:20 -0300 (ADT) Received: from linuxworld.com.au (IDENT:swm@localhost.localdomain [127.0.0.1]) by linuxworld.com.au (8.13.2/8.13.2) with ESMTP id j3LCXQqp031149; Thu, 21 Apr 2005 22:33:26 +1000 Received: from localhost (swm@localhost) by linuxworld.com.au (8.13.2/8.13.2/Submit) with ESMTP id j3LCXQ4U031146; Thu, 21 Apr 2005 22:33:26 +1000 X-Authentication-Warning: linuxworld.com.au: swm owned process doing -bs Date: Thu, 21 Apr 2005 22:33:26 +1000 (EST) From: Gavin Sherry X-X-Sender: swm@linuxworld.com.au To: Jeff Cc: "Shoaib Burq (VPAC)" , pgsql-performance@postgresql.org Subject: Re: two queries and dual cpu (perplexed) In-Reply-To: <8c459b7b96e6c310d641cebdfa8dcab6@torgo.978.org> Message-ID: References: <8c459b7b96e6c310d641cebdfa8dcab6@torgo.978.org> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.003 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200504/555 X-Sequence-Number: 11952 On Thu, 21 Apr 2005, Jeff wrote: > > On Apr 21, 2005, at 7:49 AM, Shoaib Burq (VPAC) wrote: > > > Now I have not touch the $PGDATA/postgresql.conf (As I know very little > > about memory tuning) Have run VACCUM & ANALYZE. > > > You should really, really bump up shared_buffers and given you have 8GB > of ram this query would likely benefit from more work_mem. I'd recommend shared_buffers = 10600. Its possible that work_mem in the hundreds of megabytes might have a good impact, but its hard to say without seeing the EXPLAIN ANALYZE output. Gavin