"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...
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 Munro||Date: 2002-02-22 03:35:42|
|Subject: point in time recovery and moving datafiles online|
|Previous:||From: Tom Lane||Date: 2002-02-22 03:15:44|
|Subject: Re: Are stored procedures pre-compiled? |