pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Stored Procedures and compiling
3+ messages / 2 participants
[nested] [flat]

* Stored Procedures and compiling
@ 2003-03-07 21:21 Daniel Bruce Lynes <dlynes@shaw.ca>
  2003-03-08 03:13 ` Re: Stored Procedures and compiling Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 1 reply; 3+ messages in thread

From: Daniel Bruce Lynes @ 2003-03-07 21:21 UTC (permalink / raw)
  To: pgsql-performance

Hello.

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?

Thanks



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Stored Procedures and compiling
  2003-03-07 21:21 Stored Procedures and compiling Daniel Bruce Lynes <dlynes@shaw.ca>
@ 2003-03-08 03:13 ` Tom Lane <tgl@sss.pgh.pa.us>
  2003-03-08 18:34   ` Re: Stored Procedures and compiling Daniel Bruce Lynes <dlynes@shaw.ca>
  0 siblings, 1 reply; 3+ messages in thread

From: Tom Lane @ 2003-03-08 03:13 UTC (permalink / raw)
  To: Daniel Bruce Lynes <dlynes@shaw.ca>; +Cc: 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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Stored Procedures and compiling
  2003-03-07 21:21 Stored Procedures and compiling Daniel Bruce Lynes <dlynes@shaw.ca>
  2003-03-08 03:13 ` Re: Stored Procedures and compiling Tom Lane <tgl@sss.pgh.pa.us>
@ 2003-03-08 18:34   ` Daniel Bruce Lynes <dlynes@shaw.ca>
  0 siblings, 0 replies; 3+ messages in thread

From: Daniel Bruce Lynes @ 2003-03-08 18:34 UTC (permalink / raw)
  To: pgsql-performance

On Friday 07 March 2003 19:13, Tom Lane wrote:

> 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?

When you run a script to place a stored procedure into Oracle, it checks the 
entire script to ensure that there are no syntax errors in both the 
procedural code and the SQL code.  However, with PostgreSQL, if there are 
errors in the code, I usually don't find out about it until I reach that 
branch in the logic upon execution of the stored procedure from client code.

As I understand it, Oracle also compiles the stored procedure into pcode 
(internally), the first time it is called so that it runs faster.  You can 
compile stored procedures into pcode manually also, and store the pcode in 
the database, rather than the pl/sql code.



^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2003-03-08 18:34 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-03-07 21:21 Stored Procedures and compiling Daniel Bruce Lynes <dlynes@shaw.ca>
2003-03-08 03:13 ` Tom Lane <tgl@sss.pgh.pa.us>
2003-03-08 18:34   ` Daniel Bruce Lynes <dlynes@shaw.ca>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox