Matthew Lunnon wrote:
> Ahh, sorry, I have been too aggressive with my cutting, I am running
> 8.2.6 and the function is below.
> 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
In response to
pgsql-performance by date
|Next:||From: Adrian Moisey||Date: 2008-01-29 14:28:45|
|Previous:||From: Mike Smith||Date: 2008-01-29 11:43:15|
|Subject: Re: 8x2.5" or 6x3.5" disks|