> 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.
any tips on how to verify this?
In response to
pgsql-performance by date
|Next:||From: Joel Fradkin||Date: 2005-04-21 14:53:51|
|Subject: Re: [PERFORM] Joel's Performance Issues WAS : Opteron vs Xeon|
|Previous:||From: Mohan, Ross||Date: 2005-04-21 14:42:16|
|Subject: Re: Joel's Performance Issues WAS : Opteron vs Xeon|