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

Re: Are stored procedures pre-compiled?

From: Doug McNaught <doug(at)wireboard(dot)com>
To: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
Cc: "Hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Are stored procedures pre-compiled?
Date: 2002-02-22 03:23:23
Message-ID: m3ofii5hec.fsf@varsoon.denali.to (view raw or flat)
Thread:
Lists: pgsql-hackers
"Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au> writes:

> Hi Hackers,
> 
> Are stored sql or pl/pgsql (and in fact other langs) precompiled on Postgres
> for efficiency???

I'm not sure what happens with SQL, I think it's just stored as text.

PL/pgSQL is parsed and stored as a parse tree for execution.  Perl
does basically the same thing IIRC, and Python compiles to byte-code.
I'm not sure about TCL...

-Doug
-- 
Let us cross over the river, and rest under the shade of the trees.
   --T. J. Jackson, 1863

In response to

pgsql-hackers by date

Next:From: Marc MunroDate: 2002-02-22 03:35:42
Subject: point in time recovery and moving datafiles online
Previous:From: Tom LaneDate: 2002-02-22 03:15:44
Subject: Re: Are stored procedures pre-compiled?

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