Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 2247E9FA17F for ; Thu, 30 Nov 2006 17:28:16 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024) with ESMTP id 90221-06 for ; Thu, 30 Nov 2006 17:28:03 -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.171]) by postgresql.org (Postfix) with ESMTP id 1C8E49FA170 for ; Thu, 30 Nov 2006 17:28:05 -0400 (AST) Received: by ug-out-1314.google.com with SMTP id k3so2021572ugf for ; Thu, 30 Nov 2006 13:28:04 -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:mime-version:content-type:x-google-sender-auth; b=RGnMgVP3x4sSlr3CWa+Sp6majgMVIeNTPwoUy1IAjFxQ+FRGbXVZYyO3+FA+qC1WCNEorMTqEv+idUn+h/qrw9YcOglGG++Wl+LdL/jcth3Ph/DkrP40MMtpvcoSjB4iCwzv33UvCbhlt9YNHFjh+KusAvQaNZlblA9KIp7L4iU= Received: by 10.78.17.1 with SMTP id 1mr4006931huq.1164922084443; Thu, 30 Nov 2006 13:28:04 -0800 (PST) Received: by 10.78.136.6 with HTTP; Thu, 30 Nov 2006 13:28:04 -0800 (PST) Message-ID: Date: Thu, 30 Nov 2006 15:28:04 -0600 From: "Aaron Bono" To: "Lista Postgres" Subject: PostgreSQL and Performance of Functions MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_45070_4686803.1164922084390" X-Google-Sender-Auth: 74d6af3bbcb399f4 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/265 X-Sequence-Number: 23792 ------=_Part_45070_4686803.1164922084390 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline 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. 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 -- ================================================================== Aaron Bono Aranya Software Technologies, Inc. http://www.aranya.com http://codeelixir.com ================================================================== ------=_Part_45070_4686803.1164922084390 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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.

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

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