From: Jeff <threshar@torgo.978.org>
To: Shoaib Burq (VPAC) <sab@vpac.org>
Cc: pgsql-performance@postgresql.org
Subject: Re: two queries and dual cpu (perplexed)
Date: Thu, 21 Apr 2005 08:24:15 -0400
Message-ID: <8c459b7b96e6c310d641cebdfa8dcab6@torgo.978.org> (raw)
In-Reply-To: <Pine.LNX.4.44.0504212109050.28107-100000@hp.vpac.org>
References: <Pine.LNX.4.44.0504212109050.28107-100000@hp.vpac.org>
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@jefftrout.com>
http://www.jefftrout.com/http://www.stuarthamm.net/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: threshar@torgo.978.org, sab@vpac.org
Subject: Re: two queries and dual cpu (perplexed)
In-Reply-To: <8c459b7b96e6c310d641cebdfa8dcab6@torgo.978.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox