Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 83E219FBC34 for ; Fri, 23 Mar 2007 10:09:35 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024) with ESMTP id 38074-06 for ; Fri, 23 Mar 2007 10:09:22 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from vms040pub.verizon.net (vms040pub.verizon.net [206.46.252.40]) by postgresql.org (Postfix) with ESMTP id 958659FBC7C for ; Fri, 23 Mar 2007 10:09:28 -0300 (ADT) Received: from osgiliath.mathom.us ([72.66.31.15]) by vms040.mailsrvcs.net (Sun Java System Messaging Server 6.2-6.01 (built Apr 3 2006)) with ESMTPA id <0JFC001TXXVF06F1@vms040.mailsrvcs.net> for pgsql-performance@postgresql.org; Fri, 23 Mar 2007 08:09:16 -0500 (CDT) Received: from localhost (localhost [127.0.0.1]) by osgiliath.mathom.us (Postfix) with ESMTP id 672416FB20 for ; Fri, 23 Mar 2007 09:09:14 -0400 (EDT) Received: from osgiliath.mathom.us ([127.0.0.1]) by localhost (osgiliath.home.mathom.us [127.0.0.1]) (amavisd-new, port 10024) with LMTP id 6PFZHCoUMqA7 for ; Fri, 23 Mar 2007 09:09:13 -0400 (EDT) Received: by osgiliath.mathom.us (Postfix, from userid 1000) id 0F1167138A; Fri, 23 Mar 2007 09:09:12 -0400 (EDT) Date: Fri, 23 Mar 2007 09:09:12 -0400 From: Michael Stone Subject: Re: Performance of count(*) In-reply-to: <4603C17E.709@wildenhain.de> To: pgsql-performance@postgresql.org Mail-followup-to: pgsql-performance@postgresql.org Message-id: <20070323130910.GL11402@mathom.us> MIME-version: 1.0 Content-type: text/plain; charset=us-ascii; format=flowed Content-disposition: inline X-Virus-Scanned: Debian amavisd-new at mathom.us X-Pgp-Fingerprint: 53 FF 38 00 E7 DD 0A 9C 84 52 84 C5 EE DF 7C 88 References: <200703221208.19358.albert@sedifa.com> <20070322141807.GE11402@mathom.us> <46029DE3.9030505@modgraph-usa.com> <4602A15B.7000908@wildenhain.de> <4602BB19.9050306@modgraph-usa.com> <4602BC84.8030101@wildenhain.de> <20070322173930.GI11402@mathom.us> <4603C17E.709@wildenhain.de> User-Agent: Mutt/1.5.13 (2006-08-11) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200703/364 X-Sequence-Number: 23769 On Fri, Mar 23, 2007 at 01:01:02PM +0100, Tino Wildenhain wrote: >This discussion is a bit theoretical until we see the actual problem >and the proposed solution here. It's good to see you back off a bit from your previous stance of assuming that someone doesn't know what they're doing and that their solution is absolutely wrong without actually knowing anything about what they are trying to do. Mike Stone