X-Original-To: pgsql-performance@postgresql.org Received: from pd2mo3so.prod.shaw.ca (shawidc-mo1.cg.shawcable.net [24.71.223.10]) by postgresql.org (Postfix) with ESMTP id A58F247622E for ; Fri, 7 Mar 2003 16:09:53 -0500 (EST) Received: from pd3mr3so.prod.shaw.ca (pd3mr3so-ser.prod.shaw.ca [10.0.141.179]) by l-daemon (iPlanet Messaging Server 5.1 HotFix 0.8 (built May 12 2002)) with ESMTP id <0HBE00CJZDGIZ6@l-daemon> for pgsql-performance@postgresql.org; Fri, 07 Mar 2003 14:09:54 -0700 (MST) Received: from pn2ml2so.prod.shaw.ca (pn2ml2so-qfe0.prod.shaw.ca [10.0.121.146]) by l-daemon (iPlanet Messaging Server 5.1 HotFix 0.8 (built May 12 2002)) with ESMTP id <0HBE00DFMDGIK6@l-daemon> for pgsql-performance@postgresql.org; Fri, 07 Mar 2003 14:09:54 -0700 (MST) Received: from power ([24.80.229.122]) by l-daemon (iPlanet Messaging Server 5.1 HotFix 0.8 (built May 12 2002)) with ESMTP id <0HBE00K9BDGIBJ@l-daemon> for pgsql-performance@postgresql.org; Fri, 07 Mar 2003 14:09:54 -0700 (MST) Date: Fri, 07 Mar 2003 13:21:09 -0800 From: Daniel Bruce Lynes Subject: Stored Procedures and compiling To: PostgreSQL Performance Message-id: <200303071321.09981.dlynes@shaw.ca> MIME-version: 1.0 X-Mailer: KMail [version 1.4] Content-type: text/plain; charset=gb2312 Content-transfer-encoding: 7BIT X-Archive-Number: 200303/59 X-Sequence-Number: 1357 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