X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 780C7537F6 for ; Sat, 23 Apr 2005 03:30:56 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 36142-03 for ; Sat, 23 Apr 2005 06:30:48 +0000 (GMT) Received: from sccrmhc13.comcast.net (sccrmhc13.comcast.net [204.127.202.64]) by svr1.postgresql.org (Postfix) with ESMTP id B908C540C3 for ; Sat, 23 Apr 2005 03:30:47 -0300 (ADT) Received: from sysexperts.com (c-24-6-183-218.hsd1.ca.comcast.net[24.6.183.218]) by comcast.net (sccrmhc13) with ESMTP id <2005042306304601600a987re>; Sat, 23 Apr 2005 06:30:47 +0000 Received: from localhost (localhost [127.0.0.1]) (uid 1000) by filer with local; Fri, 22 Apr 2005 23:30:45 -0700 id 000B6A45.4269EB95.000067F3 Date: Fri, 22 Apr 2005 23:30:45 -0700 From: Kevin Brown To: 'Postgresql Performance' Subject: Re: Joel's Performance Issues WAS : Opteron vs Xeon Message-ID: <20050423063044.GI19518@filer> Mail-Followup-To: Kevin Brown , 'Postgresql Performance' References: <4266F7B3.7050004@arbash-meinel.com> <000f01c54679$8d2f1f70$797ba8c0@jfradkin> <20050423020151.GW58835@decibel.org> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Content-Disposition: inline In-Reply-To: <20050423020151.GW58835@decibel.org> Organization: Frobozzco International User-Agent: Mutt/1.5.8i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.05 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200504/641 X-Sequence-Number: 12038 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