Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 0AEA41337B95 for ; Thu, 3 Feb 2011 19:01:02 -0400 (AST) 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 17802-01 for ; Thu, 3 Feb 2011 23:00:56 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from outmail149096.authsmtp.net (outmail149096.authsmtp.net [62.13.149.96]) by mail.postgresql.org (Postfix) with ESMTP id 70B871337B49 for ; Thu, 3 Feb 2011 19:00:53 -0400 (AST) Received: from mail-c187.authsmtp.com (mail-c187.authsmtp.com [62.13.128.33]) by punt8.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id p13N0paY085439; Thu, 3 Feb 2011 23:00:51 GMT Received: from Sidney-Stratton.local (dsl081-245-111.sfo1.dsl.speakeasy.net [64.81.245.111]) (authenticated bits=0) by mail.authsmtp.com (8.14.2/8.14.2) with ESMTP id p13N0lrL032924; Thu, 3 Feb 2011 23:00:48 GMT Message-ID: <4D4B3395.6010007@agliodbs.com> Date: Thu, 03 Feb 2011 15:00:37 -0800 From: Josh Berkus User-Agent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.5; en-US; rv:1.9.1b3pre) Gecko/20090223 Thunderbird/3.0b2 MIME-Version: 1.0 To: Mladen Gogala CC: Maciek Sakrejda , sthomas@peak6.com, pgsql-performance@postgresql.org Subject: Re: [HACKERS] Slow count(*) again... References: <201102012247.p11Ml6u02682@momjian.us> <4D48914B.4050403@dunslane.net> <4D489AD1.1010105@vmsinfo.com> <4D499E55.4020107@vmsinfo.com> <4D49A6B9.4060608@2ndquadrant.com> <4D49C482.4010707@vmsinfo.com> <4D49F0BA.9000901@2ndquadrant.com> <4D4A16BF.1020304@vmsinfo.com> <4D4A4844.3020409@2ndquadrant.com> <4D4AD9F6.6040903@vmsinfo.com> <4D4AE16E.9040807@peak6.com> <4D4B17B4.9030406@vmsinfo.com> <4D4B1F5B.4060403@peak6.com> <4D4B261B.6010303@vmsinfo.com> <4D4B2E8A.7010402@vmsinfo.com> In-Reply-To: <4D4B2E8A.7010402@vmsinfo.com> Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit X-Server-Quench: 713303eb-2fe9-11e0-ab46-001185d377ca X-AuthReport-Spam: If SPAM / abuse - report it at: http://www.authsmtp.com/abuse X-AuthRoute: OCdyZgscClZXSx8a IioLCC5HRQ8+YBZL BAkGMA9GIUINWEQN c1ACdR19PVdbHwkA AnYJWF5UUFd1UC1z bxRZbBtfZk9QXgRr T0pMQFdNFEsoAB9/ BkJcLhlxdQxEfDB3 ZEBmEHdaX0d6dhMv X0wCQGQbZGY1aH1O AkReagNUcQJCe0tG bVcsBT1vNG8XDQIR NCweBQsEdQZnBR57 ZTsoGBopRUEUVjU7 WhYeXXduVUQKTiQ1 aVpgQgQg X-Authentic-SMTP: 61633136333939.1000:706 X-AuthFastPath: 0 (Was 255) X-AuthVirus-Status: No virus detected - but ensure you scan with your own anti-virus system. X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201102/125 X-Sequence-Number: 42263 > I don't want to insult anybody but the whole thing does look strange. > Maybe we can agree to remove that ridiculous "we don't want hints" note > from Postgresql wiki? That would make it look less like , hmph, > philosophical issue and more "not yet implemented" issue, especially if > we have in mind that hints are already here, in the form of > "enable_" switches. Link? There's a lot of stuff on the wiki. -- -- Josh Berkus PostgreSQL Experts Inc. http://www.pgexperts.com