Hello 2011/6/8 <anthony.ship...@symstream.com>: > On Wednesday 08 June 2011 18:39, Pavel Stehule wrote: >> if you use FOR statement, there should be a problem in using a >> implicit cursor - try to set a GUC cursor_tuple_fraction to 1.0. > Alas this is mammoth replicator, equivalent to PG 8.3 and it doesn't have that > parameter.
It should be a part of problem - resp. combination with bad statistic. Maybe you should to rewrite your code to DECLARE int i = 0; FOR x IN EXECUTE '....' LOOP RETURN NEXT ... i := i + 1; EXIT WHEN i > limitvar END LOOP Regards Pavel Stehule > -- > Anthony Shipman | It's caches all the way > anthony.ship...@symstream.com | down. > -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
