On 13/05/2010 16:59, S G wrote:
> Can anyone lend a guess as to what I'm running into here, or do I need
> to provide more specifics to recreate the issue? It's repeatable, but
> it's a fair bit of data for me to just post in here as-is. I've already
> discovered a few creative workarounds (e.g. plpgsql: return query
> execute ...) that make it run faster again, but at this point, I'm
> really more interested in finding out what would make sql code run so
> much slower as a stored function in the first place.
It would help if you post the output from EXPLAIN ANALYZE for each case,
as this will hopefully show where the bottleneck is.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie