Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Performance problems inside a stored procedure.
- From: Euler Taveira de Oliveira <euler(at)timbira(dot)com>
- To: mlunnon(at)rwa-net(dot)co(dot)uk
- Cc: pgsql-performance(at)postgresql(dot)org, Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
- Subject: Re: Performance problems inside a stored procedure.
- Date: Tue, 29 Jan 2008 11:59:19 -0200
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/
- Follow-Ups:
- Re: Performance problems inside a stored procedure.
- From: Matthew Lunnon
- Re: Performance problems inside a stored procedure.
- References:
- Performance problems inside a stored procedure.
- From: Matthew Lunnon
- Re: Performance problems inside a stored procedure.
- From: Heikki Linnakangas
- Re: Performance problems inside a stored procedure.
- From: Matthew Lunnon
- Performance problems inside a stored procedure.
- Prev by Date: Re: 8x2.5" or 6x3.5" disks
- Next by Date: analyze
- Previous by thread: Re: Performance problems inside a stored procedure.
- Next by thread: Re: Performance problems inside a stored procedure.
- Indexes: