Re: [HACKERS] Re: pgsql: Add missing optimizer hooks for function cost and number of rows.

Поиск
Список
Период
Сортировка
От Simon Riggs
Тема Re: [HACKERS] Re: pgsql: Add missing optimizer hooks for function cost and number of rows.
Дата
Msg-id 1272129226.4161.1596.camel@ebony
обсуждение исходный текст
Ответ на Re: [HACKERS] Re: pgsql: Add missing optimizer hooks for function cost and number of rows.  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-committers
On Sat, 2010-04-24 at 12:59 -0400, Tom Lane wrote:

> Well, you did it without much thought at all.

To the consequences, definitely.

> I think this episode is a
> perfect demonstration of why we ask for concrete use-cases for proposed
> hooks.  If you'd actually tried to write something that used the hook,
> you'd surely have noticed that it wasn't being passed the information
> that it would need to do anything useful, and you'd probably have
> recognized the problem that there's no good way for a single hook
> function to provide an extensible collection of function-specific
> knowledge.

To the value, no. The limitations of the hook approach were clear, but
they do at least allow overriding values on a session by session basis,
allowing you to write a program to estimate the result and then set the
function costs accordingly. It's not clever or the best way, but it was
the same situation as the other hooks currently provide and I imagined
it would be accepted without question, wrongly.

--
 Simon Riggs           www.2ndQuadrant.com


В списке pgsql-committers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] Re: pgsql: Add missing optimizer hooks for function cost and number of rows.
Следующее
От: momjian@postgresql.org (Bruce Momjian)
Дата:
Сообщение: pgsql: Add C comments for recent to_char('L') fix for Win32.