Skip site navigation (1) Skip section navigation (2)

Re: Are stored procedures pre-compiled?

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Neil Conway <nconway(at)klamath(dot)dyndns(dot)org>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Are stored procedures pre-compiled?
Date: 2002-02-22 05:22:02
Message-ID: 200202220522.g1M5M2Z22897@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Already on TODO, your name added.

---------------------------------------------------------------------------

Neil Conway wrote:
> On Thu, 2002-02-21 at 23:11, Tom Lane wrote:
> > Neil Conway <nconway(at)klamath(dot)dyndns(dot)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(at)rogers(dot)com>
> PGP Key ID: DB3C29FC
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
> 

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2002-02-22 05:27:56
Subject: Re: point in time recovery and moving datafiles online
Previous:From: Peter EisentrautDate: 2002-02-22 05:16:00
Subject: Re: Summary of new configuration file and data directory

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group