| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-04-22 05:57:11 | Re: Index bloat problem? |
| Previous Message | Alvaro Herrera | 2005-04-22 03:55:21 | Re: foreign key performance |