Re: Stored Procedures and compiling

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Daniel Bruce Lynes <dlynes(at)shaw(dot)ca>
Cc: PostgreSQL Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Stored Procedures and compiling
Date: 2003-03-08 03:13:24
Message-ID: 3240.1047093204@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Daniel Bruce Lynes <dlynes(at)shaw(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Manfred Koizar 2003-03-08 10:15:56 Re: Slow query performance on large table
Previous Message Greg Stark 2003-03-08 02:39:09 Re: Index / Performance issues