David Kerr <d...@mr-paradox.net> writes:
> for example: If a java program connects to the DB and does "begin;"
> and then internally does a "sleep 6 days"
> Does that cauz any issues other than eating a connection to the database?
In recent versions of PG, no. Before about 8.3 it was a Really Bad Idea,
because the open transaction would prevent VACUUM from reclaiming storage.
It's *still* a Really Bad Idea to begin a transaction, do something,
and then sleep 6 days. But "BEGIN" without any following commands
has been fixed to be harmless, mainly because there are so many
badly designed clients that do exactly that ...
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
