| From: | Jeff <threshar(at)torgo(dot)978(dot)org> |
|---|---|
| To: | "Shoaib Burq (VPAC)" <sab(at)vpac(dot)org> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: two queries and dual cpu (perplexed) |
| Date: | 2005-04-21 12:24:15 |
| Message-ID: | 8c459b7b96e6c310d641cebdfa8dcab6@torgo.978.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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.
> and the time taken is *twice* that for the original. The modification
> was
> minor. The queries do make use of both CPUs:
>
Is this an IO intensive query? If running both in parellel results in
2x the run time and you have sufficient cpus it would (to me) indicate
you don't have enough IO bandwidth to satisfy the query.
Can we see an explain analyze of the query? Could be a bad plan and a
bad plan will never give good performance.
--
Jeff Trout <jeff(at)jefftrout(dot)com>
http://www.jefftrout.com/
http://www.stuarthamm.net/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gavin Sherry | 2005-04-21 12:33:26 | Re: two queries and dual cpu (perplexed) |
| Previous Message | Daniel Schuchardt | 2005-04-21 12:19:06 | Re: two queries and dual cpu (perplexed) |