Re: Joel's Performance Issues WAS : Opteron vs Xeon - Mailing list pgsql-performance

From Kevin Brown
Subject Re: Joel's Performance Issues WAS : Opteron vs Xeon
Date
Msg-id 20050423063044.GI19518@filer
Whole thread Raw
In response to Re: Joel's Performance Issues WAS : Opteron vs Xeon  ("Jim C. Nasby" <decibel@decibel.org>)
Responses Re: Joel's Performance Issues WAS : Opteron vs Xeon
List pgsql-performance
Jim C. Nasby wrote:
> Hrm... I was about to suggest that for timing just the query (and not
> output/data transfer time) using explain analyze, but then I remembered
> that explain analyze can incur some non-trivial overhead with the timing
> calls. Is there a way to run the query but have psql ignore the output?
> If so, you could use \timing.

Would timing "SELECT COUNT(*) FROM (query)" work?


--
Kevin Brown                          kevin@sysexperts.com

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Sort and index
Next
From: Greg Stark
Date:
Subject: Re: Bad n_distinct estimation; hacks suggested?