Tuesday, August 12, 2008

Re: [PERFORM] long transaction

> long running transactions can be evil. is there a reason why this has
> to run in a single transaction?

This single transaction is used to import new information in a database. I
need it because the database cannot be disconected from the users, and the
whole new data has to be consistently. There are different constraints that
are checked during the import.

--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

No comments: