Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 9E6359FA136 for ; Fri, 1 Dec 2006 20:23:49 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 91575-07 for ; Fri, 1 Dec 2006 20:23:45 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.172]) by postgresql.org (Postfix) with ESMTP id 2282C9F942F for ; Fri, 1 Dec 2006 20:21:14 -0400 (AST) Received: by ug-out-1314.google.com with SMTP id k3so2320341ugf for ; Fri, 01 Dec 2006 16:21:13 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:sender:to:subject:cc:in-reply-to:mime-version:content-type:references:x-google-sender-auth; b=hss9M8IaNXCYP2RbNGPHna24GtdpDUKfTtfQFXVO5VPo+twtFX/S8O41EeqMF/3gkH/Sy3A9esvl4iBllItQO2YjoHBEmkM6GCRoa5AZD1zK/jHHNmAO1ZydhsWJh9UE4Wx4DCjW/A9aTZSKT81g8wPE+U3bYGi94HbMJux/+U0= Received: by 10.78.157.8 with SMTP id f8mr5489588hue.1165018872706; Fri, 01 Dec 2006 16:21:12 -0800 (PST) Received: by 10.78.136.6 with HTTP; Fri, 1 Dec 2006 16:21:12 -0800 (PST) Message-ID: Date: Fri, 1 Dec 2006 18:21:12 -0600 From: "Aaron Bono" To: "Rajesh Kumar Mallah" Subject: Re: PostgreSQL and Performance of Functions Cc: "Lista Postgres" In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_6564_19773930.1165018872606" References: X-Google-Sender-Auth: fc7ba5620b44fcb4 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/13 X-Sequence-Number: 23805 ------=_Part_6564_19773930.1165018872606 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline On 12/1/06, Rajesh Kumar Mallah wrote: > > > > On 12/1/06, Aaron Bono wrote: > > > > Recently I have been put on a project that uses DB2 (not my choice). I > > am using functions for reports and was told this may not be allowed. They > > said: > > > > One gap is the ability to tune the code in the function (not really > > static) or to perform real-time analysis of performance problems. > > > > Tuning the code in function requires to change the file containing the > function > defination and reloading the function. Hence the cycle of performance > tuning is > longer. > > Regarding "real time analysis" what I understand is > > EXPLAIN ANALYSE (of main SQL using the function) in postgresql cannot > provide the realtime analysis of the performace of queries inside the > function. > probably such a limitation may exists in db2 also. > > I think the gap is genuine. > > > I normally use PostgreSQL for all my applications (this being an > > exception). Does anyone know what this statement is about and, more > > importantly, does PostgreSQL have the same limitations? > > > > Thanks, > > Aaron > > > > > I was told that, for DB2, stored procedures are a better choice for parameterized views which is what I was trying to do with the functions. Is the same true for PostgreSQL? -Aaron -- ================================================================== Aaron Bono Aranya Software Technologies, Inc. http://www.aranya.com http://codeelixir.com ================================================================== ------=_Part_6564_19773930.1165018872606 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline On 12/1/06, Rajesh Kumar Mallah <mallah.rajesh@gmail.com> wrote:


On 12/1/06, Aaron Bono < postgresql@aranya.com> wrote:
Recently I have been put on a project that uses DB2 (not my choice).  I am using functions for reports and was told this may not be allowed.  They said:

One gap is the ability to tune the code in the function (not really static) or to perform real-time analysis of performance problems.

Tuning the code in function requires to change the file containing the function
defination and reloading the function. Hence the cycle of performance tuning is
longer.

Regarding "real time analysis" what I understand is

EXPLAIN ANALYSE (of main SQL using the function) in postgresql cannot
provide the realtime analysis of the performace of queries inside the function.
probably such a limitation may exists in db2 also.

I think the gap is genuine.


I normally use PostgreSQL for all my applications (this being an exception).  Does anyone know what this statement is about and, more importantly, does PostgreSQL have the same limitations?

Thanks,
Aaron




I was told that, for DB2, stored procedures are a better choice for parameterized views which is what I was trying to do with the functions.  Is the same true for PostgreSQL?

-Aaron


--
==================================================================
   Aaron Bono
   Aranya Software Technologies, Inc.
   http://www.aranya.com
   http://codeelixir.com
================================================================== ------=_Part_6564_19773930.1165018872606--