Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id AE808133740B for ; Thu, 3 Feb 2011 18:42:10 -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 11197-05 for ; Thu, 3 Feb 2011 22:42:00 +0000 (UTC) X-Greylist: delayed 00:22:47.774537 by SQLgrey-1.7.6 Received: from proton.planetargon.com (proton.planetargon.com [198.145.115.11]) by mail.postgresql.org (Postfix) with ESMTP id E9E121337B2F for ; Thu, 3 Feb 2011 18:41:58 -0400 (AST) Received: by proton.planetargon.com (Postfix, from userid 502) id CE7AD82DDDC; Thu, 3 Feb 2011 14:19:09 -0800 (PST) Received: from [192.168.2.4] (unknown [68.64.144.221]) by proton.planetargon.com (Postfix) with ESMTP id 23D4B82DDD9; Thu, 3 Feb 2011 14:19:05 -0800 (PST) Subject: Re: [HACKERS] Slow count(*) again... Mime-Version: 1.0 (Apple Message framework v1082) Content-Type: text/plain; charset=us-ascii From: Michael Glaesemann In-Reply-To: <4D4B2740.3070902@agliodbs.com> Date: Thu, 3 Feb 2011 17:19:04 -0500 Cc: pgsql-performance@postgresql.org Content-Transfer-Encoding: quoted-printable Message-Id: <592C8787-E659-49C8-AFD1-96A8B25331DC@seespotcode.net> 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> To: Josh Berkus X-Mailer: Apple Mail (2.1082) 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/123 X-Sequence-Number: 42261 On Feb 3, 2011, at 17:08, Josh Berkus wrote: > On 2/3/11 1:18 PM, Chris Browne wrote: >> mladen.gogala@vmsinfo.com (Mladen Gogala) writes: >>> I must say that this purist attitude is extremely surprising to >>> me. All the major DB vendors support optimizer hints, >=20 > I don't think that's actually accurate. Can you give me a list of > DBMSes which support hints other than Oracle? 1 minute of Googling shows results for: db2: = informix: = sybase: = mysql: I haven't read much of the rest of this thread, so others may have = brought these up before. Michael Glaesemann grzm seespotcode net