Re: [PERFORM] two queries and dual cpu (perplexed)

[Jeff]

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 <[EMAIL PROTECTED]>
http://www.jefftrout.com/
http://www.stuarthamm.net/
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
              http://archives.postgresql.org