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?
|
Список | 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 по дате отправления: