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 AA23253456 for ; Fri, 22 Apr 2005 00:58:32 -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 85229-08 for ; Fri, 22 Apr 2005 03:58:29 +0000 (GMT) Received: from linuxworld.com.au (unknown [203.34.46.50]) by svr1.postgresql.org (Postfix) with ESMTP id 8D4E25367E for ; Fri, 22 Apr 2005 00:57:48 -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 j3M3vMTg004287; Fri, 22 Apr 2005 13:57:24 +1000 Received: from localhost (swm@localhost) by linuxworld.com.au (8.13.2/8.13.2/Submit) with ESMTP id j3M3vH6T004284; Fri, 22 Apr 2005 13:57:19 +1000 X-Authentication-Warning: linuxworld.com.au: swm owned process doing -bs Date: Fri, 22 Apr 2005 13:57:17 +1000 (EST) From: Gavin Sherry X-X-Sender: swm@linuxworld.com.au To: "Shoaib Burq (VPAC)" Cc: John A Meinel , Russell Smith , Jeff , pgsql-performance@postgresql.org Subject: Re: two queries and dual cpu (perplexed) In-Reply-To: Message-ID: References: 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.002 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200504/605 X-Sequence-Number: 12002 On Fri, 22 Apr 2005, Shoaib Burq (VPAC) wrote: > Please see attached the output from explain analyse. This is with the > > shared_buffers = 10600 > work_mem = 102400 > enable_seqscan = true > > BTW I guess should mention that I am doing the select count(*) on a View. > > Ran the Explain analyse with the nestedloop disabled but it was taking > forever... and killed it after 30mins. Try increasing stats collection on ClimateChangeModel40.ClimateId: alter table ClimateChangeModel40 alter column ClimateId set statistics 1000; analyze ClimateChangeModel40; Gavin