Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 4278E1337B49 for ; Thu, 3 Feb 2011 18:13:17 -0400 (AST) 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 93647-04 for ; Thu, 3 Feb 2011 22:13:10 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from lpo-relay-05.vmsinfo.com (lpo-relay-05.vmsinfo.com [216.169.137.116]) by mail.postgresql.org (Postfix) with ESMTP id 010081337B5E for ; Thu, 3 Feb 2011 18:13:09 -0400 (AST) X-IronPort-AV: E=Sophos;i="4.60,422,1291611600"; d="scan'208";a="31628903" Received: from unknown (HELO lpo-mailbox-01.vmsinfo.com) ([216.169.137.252]) by lpo-relay-05.vmsinfo.com with ESMTP; 03 Feb 2011 17:13:10 -0500 Received: from [10.101.43.35] (unknown [216.169.135.235]) by lpo-mailbox-01.vmsinfo.com (Postfix) with ESMTP id F009E7D00B; Thu, 3 Feb 2011 17:13:09 -0500 (EST) Message-ID: <4D4B2875.2000500@vmsinfo.com> Date: Thu, 03 Feb 2011 17:13:09 -0500 From: Mladen Gogala Organization: VMS User-Agent: Thunderbird 2.0.0.24 (X11/20101027) MIME-Version: 1.0 To: Josh Berkus CC: "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> <871v3o3jgu.fsf@cbbrowne.afilias-int.info> <4D4B2740.3070902@agliodbs.com> <4D4B2837.6080601@vmsinfo.com> In-Reply-To: <4D4B2837.6080601@vmsinfo.com> Content-Type: text/plain; charset=UTF-8; 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/117 X-Sequence-Number: 42255 Mladen Gogala wrote: > Actually, I don't want Oracle hints. Oracle hints are ugly and > cumbersome. I would prefer something like this: > > http://dev.mysql.com/doc/refman/5.0/en/index-hints.html > > That should also answer the question about other databases supporting hints. > Sorry. I forgot that MySQL too is now an Oracle product. -- 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