Re: Functionscan estimates

Поиск
Список
Период
Сортировка
От Neil Conway
Тема Re: Functionscan estimates
Дата
Msg-id 4258B8C5.7030305@samurai.com
обсуждение исходный текст
Ответ на Re: Functionscan estimates  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
Tom Lane wrote:
> Not too many releases ago, there were several columns in pg_proc that
> were intended to support estimation of the runtime cost and number of
> result rows of set-returning functions.  I believe in fact that these
> were the remains of Joe Hellerstein's thesis on expensive-function
> evaluation

FYI, Hellerstein's thesis on xfunc optimization is available here:

     ftp://ftp.cs.wisc.edu/pub/tech-reports/reports/1996/tr1304.ps.Z

There's also a paper on this subject by Hellerstein that was published
in Transactions on Database Systems:

     http://www.cs.berkeley.edu/~jmh/miscpapers/todsxfunc.pdf

I haven't had a chance to digest either one yet, but it might be worth a
look.

-Neil

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

Предыдущее
От: tv@fuzzy.cz
Дата:
Сообщение: performance - triggers, row existence etc.
Следующее
От: Neil Conway
Дата:
Сообщение: Re: Functionscan estimates