Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id D5323B5DC0A for ; Wed, 31 Aug 2011 17:05:28 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 66723-02 for ; Wed, 31 Aug 2011 20:05:22 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from zeus.simkin.ca (zeus.simkin.ca [72.51.27.124]) by mail.postgresql.org (Postfix) with ESMTP id 099F9B5DC3A for ; Wed, 31 Aug 2011 17:05:21 -0300 (ADT) X-Postmaster: whitelisted andy@squeakycode.net Received: from pc-1072.reinvent.com (office.reinvent.com [72.51.27.254]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by zeus.simkin.ca (Postfix) with ESMTPSA id 65C94270861; Wed, 31 Aug 2011 13:05:20 -0700 (PDT) From: Alan Hodgson Organization: Simkin Network Consulting To: pgsql-performance@postgresql.org Subject: Re: Slow performance Date: Wed, 31 Aug 2011 13:05:16 -0700 User-Agent: KMail/1.13.6 (Linux/2.6.38-11-generic; KDE/4.6.2; x86_64; ; ) Cc: Andy Colson References: <201108311151.36399.ahodgson@simkin.ca> <4E5E83F8.2010409@squeakycode.net> In-Reply-To: <4E5E83F8.2010409@squeakycode.net> MIME-Version: 1.0 Content-Type: Text/Plain; charset="windows-1252" Content-Transfer-Encoding: 7bit Message-Id: <201108311305.16652.ahodgson@simkin.ca> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.404 tagged_above=-10 required=5 tests=BAYES_00=-1.9, RP_MATCHES_RCVD=-0.504 X-Spam-Level: X-Archive-Number: 201108/327 X-Sequence-Number: 44774 On August 31, 2011 11:56:56 AM Andy Colson wrote: > On 8/31/2011 1:51 PM, Alan Hodgson wrote: > > On August 31, 2011 11:26:57 AM Andy Colson wrote: > >> When you ran it, did it really feel like 30 seconds? Or did it come > >> right back real quick? > >> > >> Because your report says: > >> > 35.833 ms > >> > >> Thats ms, or milliseconds, or 0.035 seconds. > > > > I think the "." is a thousands separator in some locales, possibly the > > reason for confusion. > > D'oh. I'm zero for two today. Guess I'll call it a day. > Oh, no, you were right. I think the original poster is European, though and misread the output.