Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 372619FB38B for ; Tue, 10 Oct 2006 03:30:16 -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 60293-08 for ; Tue, 10 Oct 2006 06:30:13 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.184]) by postgresql.org (Postfix) with ESMTP id 50A9C9FB221 for ; Tue, 10 Oct 2006 03:30:13 -0300 (ADT) Received: by nf-out-0910.google.com with SMTP id m18so195430nfc for ; Mon, 09 Oct 2006 23:30:07 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=Fa6Dn4vj7pZtKFEfdnxh1b3auLAn143JZR2M4H1CxvGt1mh6eJ8FN9DVN35piNyKeD8MYyd4dRnkMxvt/N4nGHuSFC/ScIC2BK1u11eIvVUaHvlLfTY5Nzo8k0pdn9cCk1vJHlM6kCkzj9Ch3XOKQZQzxPeI02GyO6v0c3D7vpk= Received: by 10.78.139.1 with SMTP id m1mr4850367hud; Mon, 09 Oct 2006 23:30:07 -0700 (PDT) Received: by 10.78.35.18 with HTTP; Mon, 9 Oct 2006 23:30:07 -0700 (PDT) Message-ID: Date: Tue, 10 Oct 2006 12:00:07 +0530 From: "Merlin Moncure" To: "Jim C. Nasby" Subject: Re: odd variances in count(*) times Cc: "Pg Performance list" In-Reply-To: <20061009212355.GM72517@nasby.net> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <20061009183026.GT24675@kenobi.snowman.net> <20061009212355.GM72517@nasby.net> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.199 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE, SPF_PASS X-Spam-Level: X-Archive-Number: 200610/179 X-Sequence-Number: 21308 On 10/10/06, Jim C. Nasby wrote: > > >Try w/o the explain analyze. It adds quite a bit of overhead and that > > >might be inconsistant between the systems (mainly it may have to do with > > >the gettimeofday() calls being implemented differently between Windows > > >and Linux..). > > > > that was it. amd system now drop to .3 seconds, windows .6. (doing > > time foo > psql -c bar > file). thanks... > > You can also turn timing on in psql. > > And FWIW, RAID5 generally isn't a good idea for databases. thats just our development box here at the office. production system runs on something much more extravagent :). melrin