Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id A88001337B2F for ; Thu, 3 Feb 2011 18:40:25 -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 11184-04 for ; Thu, 3 Feb 2011 22:40:19 +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 0FE6C133740B for ; Thu, 3 Feb 2011 18:40:17 -0400 (AST) X-IronPort-AV: E=Sophos;i="4.60,422,1291611600"; d="scan'208";a="28387189" Received: from unknown (HELO lpo-mailbox-01.vmsinfo.com) ([216.169.137.251]) by lpo-relay-04.vmsinfo.com with ESMTP; 03 Feb 2011 17:40:17 -0500 Received: from [10.101.43.35] (unknown [216.169.135.235]) by lpo-mailbox-01.vmsinfo.com (Postfix) with ESMTP id 92E3F7D00B; Thu, 3 Feb 2011 17:40:17 -0500 (EST) Message-ID: <4D4B2ED1.1070602@vmsinfo.com> Date: Thu, 03 Feb 2011 17:40:17 -0500 From: Mladen Gogala Organization: VMS User-Agent: Thunderbird 2.0.0.24 (X11/20101027) MIME-Version: 1.0 To: Mark Kirkwood 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> <4D4B2962.7040801@catalyst.net.nz> In-Reply-To: <4D4B2962.7040801@catalyst.net.nz> 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/122 X-Sequence-Number: 42260 Mark Kirkwood wrote: > On 04/02/11 11:08, Josh Berkus wrote: > >> I don't think that's actually accurate. Can you give me a list of >> DBMSes which support hints other than Oracle? >> >> > DB2 LUW (Linux, Unix, Win32 code base) has hint profiles: > > http://justdb2chatter.blogspot.com/2008/06/db2-hints-optimizer-selection.html > > > SQL Server and MySQL too. -- 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