Postgres Pro
Downloads
Home   >   mailing lists

Re: Performance problems inside a stored procedure. - Mailing list pgsql-performance

From Euler Taveira de Oliveira
Subject Re: Performance problems inside a stored procedure.
Date
Msg-id 479F3137.2070708@timbira.com
Whole thread Raw
In response to Re: Performance problems inside a stored procedure.  (Matthew Lunnon <mlunnon@rwa-net.co.uk>)
Responses Re: Performance problems inside a stored procedure.
List pgsql-performance
Tree view 
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/

pgsql-performance by date:

Previous
From: "Mike Smith"
Date:
Subject: Re: 8x2.5" or 6x3.5" disks
Next
From: Adrian Moisey
Date:
Subject: analyze