Re: Are stored procedures pre-compiled?

Поиск
Список
Период
Сортировка
От Neil Conway
Тема Re: Are stored procedures pre-compiled?
Дата
Msg-id 1014354947.328.52.camel@jiro
обсуждение исходный текст
Ответ на Re: Are stored procedures pre-compiled?  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Are stored procedures pre-compiled?  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-hackers
On Thu, 2002-02-21 at 23:11, Tom Lane wrote:
> Neil Conway <nconway@klamath.dyndns.org> writes:
> > On Thu, 2002-02-21 at 22:15, Tom Lane wrote:
> >> I believe that SQL-language functions don't have any such optimization
> >> at all :-( ... I think they are re-parsed and re-planned from scratch
> >> on each call.
> 
> > Would it be possible to enhance SQL-language functions to cache their
> > query plan?
> 
> Certainly; if plpgsql can do it, so can SQL functions.  You could even
> steal (or better, find a way to share) a lot of the code from plpgsql.
> But no one's gotten around to it.

Okay, I'll take a look at this and see if I can implement it.

Bruce, can you add this to do the TODO list (it may be there already, I
just couldn't see it), and add me as responsible for it? Thanks.

Cheers,

Neil

-- 
Neil Conway <neilconway@rogers.com>
PGP Key ID: DB3C29FC



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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: Summary of new configuration file and data directory
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Summary of new configuration file and data directory locations