Re: Question about Idle in TX - Mailing list pgsql-general

On Tue, Aug 03, 2010 at 03:30:46PM -0400, Greg Smith wrote:
- David Kerr wrote:
- >I know that "Idle in TXs" can interfere with Vaccums for example, but
- >I'm not sure if that's due to them usually having some form of lock on a
- >table.
- >
-
- Locks aren't the issue.  When you have a transaction open, the database
- makes sure it can deliver a consistent view of the database for the

Thanks guys!

I thought that was the case but wanted to be 100% sure before i kicked up a
fuss to my developers =)

Dave