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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

Reply via email to