Heikki Linnakangas wrote:
You must be having an exception handler block in that pl/pgsql
function, which implicitly creates a new subtransaction on each
invocation of the exception handler block, so you end up with hundreds
of thousands of committed subtransactions.
I've just confirmed that that was indeed the issue, and coding around
the begin block dramatically cuts the runtimes of commands executed
after the big import function.
Thanks again!
--
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
