Re: performance of functions - or rather lack of it

From: Peter Galbavy <peter(dot)galbavy(at)knowledge(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: performance of functions - or rather lack of it
Date: 2001-04-04 10:48:23
Message-ID: 20010404114819.A337@office.knowledge.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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/

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Koen Antonissen 2001-04-04 11:01:57 restoring indices
Previous Message Peter Galbavy 2001-04-04 10:12:34 performance of functions - or rather lack of it