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@xxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
