Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id A8F5C1337B2F for ; Thu, 3 Feb 2011 18:39:16 -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 10662-04 for ; Thu, 3 Feb 2011 22:39:10 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from lpo-relay-04.vmsinfo.com (lpo-relay-04.vmsinfo.com [216.169.137.115]) by mail.postgresql.org (Postfix) with ESMTP id 4EC6A133740B for ; Thu, 3 Feb 2011 18:39:09 -0400 (AST) X-IronPort-AV: E=Sophos;i="4.60,422,1291611600"; d="scan'208";a="28387168" Received: from unknown (HELO lpo-mailbox-02.vmsinfo.com) ([216.169.137.251]) by lpo-relay-04.vmsinfo.com with ESMTP; 03 Feb 2011 17:39:07 -0500 Received: from [10.101.43.35] (lpo-autonomy-p03.vmsinfo.com [216.169.135.234]) by lpo-mailbox-02.vmsinfo.com (Postfix) with ESMTP id 02DEC56272; Thu, 3 Feb 2011 17:39:06 -0500 (EST) Message-ID: <4D4B2E8A.7010402@vmsinfo.com> Date: Thu, 03 Feb 2011 17:39:06 -0500 From: Mladen Gogala Organization: VMS User-Agent: Thunderbird 2.0.0.24 (X11/20101027) MIME-Version: 1.0 To: Maciek Sakrejda CC: "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> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-10 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201102/121 X-Sequence-Number: 42259 Maciek Sakrejda wrote: >> The hints are there because they are definitely needed. Yet, there is a >> religious zeal and a fatwa against them. >> > > The opposition is philosophical, not "religious". There is no "fatwa". > If you want a serious discussion, avoid inflammatory terms. > > > 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. -- Mladen Gogala Sr. Oracle DBA 1500 Broadway New York, NY 10036 (212) 329-5251 http://www.vmsinfo.com The Leader in Integrated Media Intelligence Solutions