Re: [GENERAL] autovacuum holds exclusive lock on table preventing it from to be updated

Поиск
Список
Период
Сортировка
От Andreas Kretschmer
Тема Re: [GENERAL] autovacuum holds exclusive lock on table preventing it from to be updated
Дата
Msg-id BC5D0E1A-62BB-4640-A430-2954C3020BEB@a-kretschmer.de
обсуждение исходный текст
Ответ на [GENERAL] autovacuum holds exclusive lock on table preventing it from to beupdated  (Dmitry O Litvintsev <litvinse@fnal.gov>)
Ответы Re: [GENERAL] autovacuum holds exclusive lock on table preventing itfrom to be updated
Список pgsql-general

Am 13. Juni 2017 20:04:04 MESZ schrieb Dmitry O Litvintsev <litvinse@fnal.gov>:
>
>I
>wraparound)                | 2017-
>| t       | enstore | autovacuum: VACUUM public.t_inodes (to prevent
>wraparound)                | 2017-06-13 12:31:04.870064-05 |
>00:28:50.276437 | 40672
>chimera | t_inodes                   |               |
>ShareUpdateExclusiveLock | t       | enstore | autovacuum: VACUUM
>public.t_inodes (to prevent wraparound)                | 2017-06-13
>12:31:04.870064-05 | 00:28:50.276437 | 40672
>

It is a autocacuum to prevent wraparound, you can't stop or avoid that.

Regards, Andreas
--
Diese Nachricht wurde von meinem Android-Mobiltelefon mit K-9 Mail gesendet.


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

Предыдущее
От: Dmitry O Litvintsev
Дата:
Сообщение: [GENERAL] autovacuum holds exclusive lock on table preventing it from to beupdated
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: [GENERAL] pg_upgrade --link on Windows