From: Euler Taveira de Oliveira <euler@timbira.com>
To: mlunnon@rwa-net.co.uk
Cc: pgsql-performance@postgresql.org, Heikki Linnakangas <heikki@enterprisedb.com>
Subject: Re: Performance problems inside a stored procedure.
Date: Tue, 29 Jan 2008 11:59:19 -0200
Message-ID: <479F3137.2070708@timbira.com> (raw)
In-Reply-To: <479DC630.9010707@rwa-net.co.uk>
References: <479DC452.8010400@rwa-net.co.uk>
<479DC558.30409@enterprisedb.com>
<479DC630.9010707@rwa-net.co.uk>
Matthew Lunnon wrote:
> Ahh, sorry, I have been too aggressive with my cutting, I am running
> 8.2.6 and the function is below.
>
<snip>
> $BODY$
> LANGUAGE 'sql' VOLATILE;
^^^^^^^^^^
I suspect that it's because you're using VOLATILE (so no good
optimizations is done); did you try STABLE? Could you show us the
EXPLAIN ANALYZE of query and function?
--
Euler Taveira de Oliveira
http://www.timbira.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 using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: euler@timbira.com, mlunnon@rwa-net.co.uk, heikki@enterprisedb.com
Subject: Re: Performance problems inside a stored procedure.
In-Reply-To: <479F3137.2070708@timbira.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