Skip site navigation (1) Skip section navigation (2)

Re: two queries and dual cpu (perplexed)

From: Gavin Sherry <swm(at)alcove(dot)com(dot)au>
To: "Shoaib Burq (VPAC)" <sab(at)vpac(dot)org>
Cc: John A Meinel <john(at)arbash-meinel(dot)com>,Russell Smith <mr-russ(at)pws(dot)com(dot)au>, Jeff <threshar(at)torgo(dot)978(dot)org>,pgsql-performance(at)postgresql(dot)org
Subject: Re: two queries and dual cpu (perplexed)
Date: 2005-04-22 03:57:17
Message-ID: Pine.LNX.4.58.0504221353370.4231@linuxworld.com.au (view raw or flat)
Thread:
Lists: pgsql-performance
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

In response to

pgsql-performance by date

Next:From: Tom LaneDate: 2005-04-22 05:57:11
Subject: Re: Index bloat problem?
Previous:From: Alvaro HerreraDate: 2005-04-22 03:55:21
Subject: Re: foreign key performance

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group