Postgres Pro
Downloads
Home   >   mailing lists

Re: Are stored procedures pre-compiled? - Mailing list pgsql-hackers

From Doug McNaught
Subject Re: Are stored procedures pre-compiled?
Date
Msg-id m3ofii5hec.fsf@varsoon.denali.to
Whole thread Raw
In response to Are stored procedures pre-compiled?  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
List pgsql-hackers
Tree view 
"Christopher Kings-Lynne" <chriskl@familyhealth.com.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

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Are stored procedures pre-compiled?
Next
From: Marc Munro
Date:
Subject: point in time recovery and moving datafiles online