From: Peter Galbavy <peter.galbavy@knowledge.com>
To: pgsql-sql@postgresql.org
Subject: Re: performance of functions - or rather lack of it
Date: Wed, 4 Apr 2001 11:48:23 +0100
Message-ID: <20010404114819.A337@office.knowledge.com> (raw)
In-Reply-To: <00bc01c0bcef$c527cf20$6601a8c0@knowledge.com>
References: <00bc01c0bcef$c527cf20$6601a8c0@knowledge.com>
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/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: peter.galbavy@knowledge.com
Subject: Re: performance of functions - or rather lack of it
In-Reply-To: <20010404114819.A337@office.knowledge.com>
References: <00bc01c0bcef$c527cf20$6601a8c0@knowledge.com> <20010404114819.A337@office.knowledge.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox