On 02/01/2011 06:52 PM, Tom Lane wrote:
Nicos Panayides writes:
On 01/31/2011 08:48 PM, Tom Lane wrote:
It seems likely that you're getting a different plan for the generic
case because that user id isn't representative of the overall average
for the column.
I
On 01/31/2011 08:48 PM, Tom Lane wrote:
Nicos Panayides writes:
the following function takes forever to execute as is. I see 'Inserting
original actions in temporary table' and nothing after that. If i
replace orig_user_id in the FOR loop with 1811 (the same orig_user_id
pas
#x27;Found action %', action_counter;
action_counter := action_counter + 1;
END LOOP;
RETURN TRUE;
END;$BODY$
LANGUAGE plpgsql VOLATILE;
--
Regards,
Nicos Panayides
IT Manager
Magneta Technologies Ltd
Tel: +357 22721919, 22317400
Fax: +357 22721917
Web: http://www.magneta.eu
--
Sent via
