On 08/30/2012 02:34 PM, Eileen wrote:
In my case, a few problems occurred. Number 1, the process ran at least 8 hours and never finished.
You're on a very old version of Pg, so you're missing out on a lot of improvements made since then.
One of them is, if I recall correctly, an improvement to exception handling efficiency. Does your function use BEGIN ... EXCEPTION to (say) handle data validation errors?
-- Craig Ringer -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
