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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-hackers by date

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