Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 790B5B5DCB7 for ; Wed, 31 Aug 2011 15:51:46 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 57938-05 for ; Wed, 31 Aug 2011 18:51:40 +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 3C808B5DCA8 for ; Wed, 31 Aug 2011 15:51:39 -0300 (ADT) 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 3F09D2702F3 for ; Wed, 31 Aug 2011 11:51:37 -0700 (PDT) From: Alan Hodgson Organization: Simkin Network Consulting To: pgsql-performance@postgresql.org Subject: Re: Slow performance Date: Wed, 31 Aug 2011 11:51:36 -0700 User-Agent: KMail/1.13.6 (Linux/2.6.38-11-generic; KDE/4.6.2; x86_64; ; ) References: <4E5E7CF1.2040108@squeakycode.net> In-Reply-To: <4E5E7CF1.2040108@squeakycode.net> MIME-Version: 1.0 Content-Type: Text/Plain; charset="windows-1252" Content-Transfer-Encoding: 7bit Message-Id: <201108311151.36399.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/324 X-Sequence-Number: 44771 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.