Re: [PERFORM] Hints proposal - Mailing list pgsql-hackers

From Jeff Davis
Subject Re: [PERFORM] Hints proposal
Date
Msg-id 1160761481.31966.242.camel@dogma.v10.wvs
Whole thread Raw
In response to Re: [PERFORM] Hints proposal  ("Jim C. Nasby" <jim@nasby.net>)
List pgsql-hackers
On Fri, 2006-10-13 at 12:30 -0500, Jim C. Nasby wrote:
> On Fri, Oct 13, 2006 at 10:23:31AM -0700, Jeff Davis wrote:
> > Right. And I think the sane ideas are along the lines of estimate & cost
> > corrections (like Tom is saying).
> 
> Let me ask this... how long do you (and others) want to wait for those?
> It's great that the planner is continually improving, but it also
> appears that there's still a long road ahead. Having a dune-buggy to get
> to your destination ahead of the road might not be a bad idea... :)

Fair enough. I can wait indefinitely right now, because I don't have any
serious problems with the planner as-is.

I am trying to empathize with people who are desperate to force plans
sometimes. Your original proposal included hints in the client queries.
I suggested that regexes on the server can accomplish the same goal
while avoiding a serious drawback. Don't you think some kind of server
matching rule is better?

I think an idea to get the hints into the server, regardless of the
types of hints you want to use, make it more likely to be accepted.
Don't you think that's a better road to take?

Regards,Jeff Davis



pgsql-hackers by date:

Previous
From: David Fetter
Date:
Subject: Re: [PERFORM] Hints proposal
Next
From: Andrew Dunstan
Date:
Subject: Re: [PERFORM] Hints proposal