Re: Question about Idle in TX

David Kerr <dmk@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