Re: Question about Idle in TX

Поиск
Список
Период
Сортировка
От David Kerr
Тема Re: Question about Idle in TX
Дата
Msg-id 20100803193333.GA53503@mr-paradox.net
обсуждение исходный текст
Ответ на Re: Question about Idle in TX  (Greg Smith <greg@2ndquadrant.com>)
Список 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

В списке pgsql-general по дате отправления:

Предыдущее
От: Merlin Moncure
Дата:
Сообщение: Re: Finding the primary key of tables
Следующее
От: Devrim GÜNDÜZ
Дата:
Сообщение: Re: Finding the primary key of tables