Hello 2011/6/8 <[email protected]>: > 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 > [email protected] | down. > -- Sent via pgsql-performance mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
