Re: Why we don't want hints

From: Chris Browne <cbbrowne(at)acm(dot)org>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Why we don't want hints
Date: 2011-02-10 17:25:37
Message-ID: 87tygbyf72.fsf@cbbrowne.afilias-int.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-performance

robertmhaas(at)gmail(dot)com (Robert Haas) writes:
> On Thu, Feb 10, 2011 at 11:45 AM, Kevin Grittner
> <Kevin(dot)Grittner(at)wicourts(dot)gov> 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.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Kevin Grittner 2011-02-10 17:27:18 Re: Why we don't want hints Was: Slow count(*) again...
Previous Message Kevin Grittner 2011-02-10 17:21:51 Re: Why we don't want hints Was: Slow count(*) again...

Browse pgsql-performance by date

  From Date Subject
Next Message Kevin Grittner 2011-02-10 17:27:18 Re: Why we don't want hints Was: Slow count(*) again...
Previous Message Kevin Grittner 2011-02-10 17:21:51 Re: Why we don't want hints Was: Slow count(*) again...