Re: Question about Idle in TX

From: David Kerr <dmk(at)mr-paradox(dot)net>
To: Greg Smith <greg(at)2ndquadrant(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Question about Idle in TX
Date: 2010-08-03 19:33:33
Message-ID: 20100803193333.GA53503@mr-paradox.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Devrim GÜNDÜZ 2010-08-03 19:33:40 Re: Finding the primary key of tables
Previous Message Merlin Moncure 2010-08-03 19:32:11 Re: Finding the primary key of tables