Re: [PERFORM] Hints proposal

Поиск
Список
Период
Сортировка
От Jeff Davis
Тема Re: [PERFORM] Hints proposal
Дата
Msg-id 1160761481.31966.242.camel@dogma.v10.wvs
обсуждение исходный текст
Ответ на Re: [PERFORM] Hints proposal  ("Jim C. Nasby" <jim@nasby.net>)
Список 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 по дате отправления:

Предыдущее
От: David Fetter
Дата:
Сообщение: Re: [PERFORM] Hints proposal
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: [PERFORM] Hints proposal