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;
In response to
pgsql-performance by date
|Next:||From: Tom Lane||Date: 2005-04-22 05:57:11|
|Subject: Re: Index bloat problem? |
|Previous:||From: Alvaro Herrera||Date: 2005-04-22 03:55:21|
|Subject: Re: foreign key performance|