Re: Vacuum as "easily obtained" locks

Поиск
Список
Период
Сортировка
От John R Pierce
Тема Re: Vacuum as "easily obtained" locks
Дата
Msg-id 4E398646.4030207@hogranch.com
обсуждение исходный текст
Ответ на Re: Vacuum as "easily obtained" locks  (Eduardo Morras <nec556@retena.com>)
Список pgsql-general
On 08/03/11 10:21 AM, Eduardo Morras wrote:
> One question, while you run your tests, does "IDLE IN TRANSACTION"
> messages happen? If you run your tests with a permanent connection to
> database, the tables are locked and autovacuum cannot work.

its not that tables are locked, its that vacuum (auto or otherwise)
can't clear any tuples newer than the oldest active transaction.

--
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast


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

Предыдущее
От: Eduardo Morras
Дата:
Сообщение: Re: Vacuum as "easily obtained" locks
Следующее
От: Eduardo Morras
Дата:
Сообщение: Re: Vacuum as "easily obtained" locks