Re: Stored Procedures and compiling - Mailing list pgsql-performance

From Tom Lane
Subject Re: Stored Procedures and compiling
Date
Msg-id 3240.1047093204@sss.pgh.pa.us
Whole thread Raw
In response to Stored Procedures and compiling  (Daniel Bruce Lynes <dlynes@shaw.ca>)
Responses Re: Stored Procedures and compiling  (Daniel Bruce Lynes <dlynes@shaw.ca>)
List pgsql-performance
Daniel Bruce Lynes <dlynes@shaw.ca> writes:
> I am curious if there is any planned support for full stored procedure
> compiling?  I've seen that PostgreSQL does not compile the SQL code inside
> plpgsql code.  It is merely interpreted when the procedure gets called.  This
> is also documented in the main html documentation.
> What I am wondering specifically is if stored procedure compiling will work
> similar to Oracle's stored procedure compilation in the future?

What exactly do you consider "compiling", and why do you think that
whatever Oracle does (which you didn't bother to explain) is superior
to what plpgsql does?

            regards, tom lane

pgsql-performance by date:

Previous
From: Greg Stark
Date:
Subject: Re: Index / Performance issues
Next
From: Manfred Koizar
Date:
Subject: Re: Slow query performance on large table