On Wed, Jan 18, 2006 at 10:35:48PM -0500, uwcssa wrote: > I am testing the performance of postgresql on a set of workloads. However, > the output significantly affects the performance evaluation. Is there a way > to by-pass all output of select statements so the timing reflects only the > query evaluation process?
SELECT count(*) FROM (SELECT ...) a; If you're using psql \timing will probably be useful as well. And this is better suited for -general... -- Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED] Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
