Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 366EC1337B7E for ; Thu, 10 Feb 2011 14:21:10 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 67230-03 for ; Thu, 10 Feb 2011 18:21:03 +0000 (UTC) Received: from news.hub.org (news.hub.org [200.46.204.72]) by mail.postgresql.org (Postfix) with ESMTP id 0124E1337B54 for ; Thu, 10 Feb 2011 14:21:03 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.14.4/8.14.4) with ESMTP id p1AIL21M014085 for ; Thu, 10 Feb 2011 14:21:02 -0400 (AST) (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.14.4/8.14.4/Submit) id p1AI82RK088539 for pgsql-performance@postgresql.org; Thu, 10 Feb 2011 14:08:02 -0400 (AST) (envelope-from news) From: Chris Browne X-Newsgroups: pgsql.performance Subject: Re: Why we don't want hints Date: Thu, 10 Feb 2011 12:25:37 -0500 Organization: cbbrowne Computing Inc Lines: 31 Message-ID: <87tygbyf72.fsf@cbbrowne.afilias-int.info> References: <201102012247.p11Ml6u02682@momjian.us> <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> <4D4B3395.6010007@agliodbs.com> <4D4B394E.9080505@vmsinfo.com> <4D4B5A73.3080302@agliodbs.com> <4D53C1C0020000250003A783@gw.wicourts.gov> Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit X-Complaints-To: usenet@news.hub.org User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/24.0.50 (gnu/linux) Cancel-Lock: sha1:esNvW5dWvfEZp//6rtzbgiYEVk4= To: pgsql-performance@postgresql.org 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/340 X-Sequence-Number: 42478 robertmhaas@gmail.com (Robert Haas) writes: > On Thu, Feb 10, 2011 at 11:45 AM, Kevin Grittner > wrote: >> Well, I'm comfortable digging in my heels against doing *lame* hints >> just because "it's what all the other kids are doing," which I think >> is the only thing which would have satisfied the OP on this thread. >> From both on-list posts and ones exchanged off-list with me, it >> seems he was stubbornly resistant to properly tuning the server to >> see if any problems remained, or posting particular problems to see >> how they would be most effectively handled in PostgreSQL.  We >> obviously can't be drawn into dumb approaches because of >> ill-informed demands like that. > > Nor was I proposing any such thing. But that doesn't make "we don't > want hints" an accurate statement. Despite the impression that OP > went away with, the real situation is a lot more nuanced than that, > and the statement on the Todo list gives the wrong impression, IMHO. I have added the following comment to the ToDo: We are not interested to implement hints in ways they are commonly implemented on other databases, and proposals based on "because they've got them" will not be welcomed. If you have an idea that avoids the problems that have been observed with other hint systems, that could lead to valuable discussion. That seems to me to characterize the nuance. -- let name="cbbrowne" and tld="gmail.com" in String.concat "@" [name;tld];; http://www3.sympatico.ca/cbbrowne/languages.html If only women came with pull-down menus and online help.