Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 3A27E9FB810 for ; Mon, 9 Oct 2006 15:45:38 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 33405-03 for ; Mon, 9 Oct 2006 18:45:29 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from cassarossa.samfundet.no (cassarossa.samfundet.no [129.241.93.19]) by postgresql.org (Postfix) with ESMTP id 24F9B9FB80B for ; Mon, 9 Oct 2006 15:45:28 -0300 (ADT) Received: from trofast.sesse.net ([129.241.93.32]) by cassarossa.samfundet.no with esmtp (Exim 4.50) id 1GX07u-0004f0-ST for pgsql-performance@postgresql.org; Mon, 09 Oct 2006 20:45:25 +0200 Received: from sesse by trofast.sesse.net with local (Exim 3.36 #1 (Debian)) id 1GX07c-0000wV-00 for ; Mon, 09 Oct 2006 20:45:04 +0200 Date: Mon, 9 Oct 2006 20:45:04 +0200 From: "Steinar H. Gunderson" To: pgsql-performance@postgresql.org Subject: Re: odd variances in count(*) times Message-ID: <20061009184504.GA3510@uio.no> Mail-Followup-To: pgsql-performance@postgresql.org References: <20061009183026.GT24675@kenobi.snowman.net> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline In-Reply-To: X-Operating-System: Linux 2.6.17.11 on a x86_64 X-Message-Flag: Outlook? --> http://www.mozilla.org/products/thunderbird/ User-Agent: Mutt/1.5.13 (2006-08-11) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200610/165 X-Sequence-Number: 21294 On Mon, Oct 09, 2006 at 02:41:07PM -0400, Merlin Moncure wrote: > that was it. amd system now drop to .3 seconds, windows .6. (doing > time foo > psql -c bar > file). thanks... What you want is probably \timing in psql, by the way. :-) /* Steinar */ -- Homepage: http://www.sesse.net/