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