Re: Function Stats WAS: Passing arguments to views

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Function Stats WAS: Passing arguments to views
Дата
Msg-id 28425.1138995173@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Function Stats WAS: Passing arguments to views  (Josh Berkus <josh@agliodbs.com>)
Ответы Re: Function Stats WAS: Passing arguments to views  (Josh Berkus <josh@agliodbs.com>)
Список pgsql-hackers
Josh Berkus <josh@agliodbs.com> writes:
> What I'd like to do is implement the constant method for 8.2, and work on 
> doing the S() method later on.  Does that make sense?

I'm not thrilled with putting in a stopgap that we will have to support
forever.  The constant method is *clearly* inadequate for many (probably
most IMHO) practical cases.  Where do you see it being of use?

W.R.T. the estimator function method, the concern about recursion seems
misplaced.  Such an estimator presumably wouldn't invoke the associated
function itself.  I'm more concerned about coming up with a usable API
for such things.  Our existing mechanisms for estimating operator
selectivities require access to internal planner data structures, which
makes it pretty much impossible to write them in anything but C.  We'd
need something cleaner to have a feature I'd want to export for general
use.
        regards, tom lane


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

Предыдущее
От: Daniel Schuchardt
Дата:
Сообщение: Re: Error working with Temporary Sequences in plpgsql in 8.1 (8.0
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: Function Stats WAS: Passing arguments to views