Re: Question about Idle in TX

David Kerr <dmk@mr-paradox.net> writes:
> On Tue, Aug 03, 2010 at 03:49:57PM -0400, Tom Lane wrote:
> - 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.

> We're on 8.3.9, so hopefully it's fairly safe then?

Should be.  You might want to test it just to make sure I'm recalling
correctly when that got fixed.  Do a BEGIN in one session, then in
another session insert and delete some rows in a table, then VACUUM
VERBOSE and see if they get cleaned up.

            regards, tom lane