Received: from mx-30.mail.knowledge.com (office.knowledge.com [213.170.2.65]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f34AmU800641 for ; Wed, 4 Apr 2001 06:48:30 -0400 (EDT) (envelope-from peter@office.knowledge.com) Received: from peter by mx-30.mail.knowledge.com with local (Exim 3.20 #1) id 14kkpr-0000Vg-00 for pgsql-sql@postgresql.org; Wed, 04 Apr 2001 11:48:23 +0100 Date: Wed, 4 Apr 2001 11:48:23 +0100 From: Peter Galbavy To: pgsql-sql@postgresql.org Subject: Re: performance of functions - or rather lack of it Message-ID: <20010404114819.A337@office.knowledge.com> References: <00bc01c0bcef$c527cf20$6601a8c0@knowledge.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: <00bc01c0bcef$c527cf20$6601a8c0@knowledge.com>; from peter.galbavy@knowledge.com on Wed, Apr 04, 2001 at 11:12:34AM +0100 X-Archive-Number: 200104/36 X-Sequence-Number: 2375 BTW The service is 7.0.2 and the client 7.1RC1 and the OSes are OpenBSD/i386 2.8-stable. On Wed, Apr 04, 2001 at 11:12:34AM +0100, Peter Galbavy wrote: > We are building a postgresql based backend database for our 'hosting > provisioning' system. In a vain attempt to add some, what I thought, simple > performance tweaks, I thought I would try putting some of the larger and > more straighforward queries into functions. For everything else the same, > the functions are on the whole slower. Should they be ? -- Peter Galbavy Knowledge Matters Ltd http://www.knowledge.com/