Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] autovacuum holds exclusive lock on table preventing it from to be updated - Mailing list pgsql-general

From Andreas Kretschmer
Subject Re: [GENERAL] autovacuum holds exclusive lock on table preventing it from to be updated
Date
Msg-id BC5D0E1A-62BB-4640-A430-2954C3020BEB@a-kretschmer.de
Whole thread Raw
In response to [GENERAL] autovacuum holds exclusive lock on table preventing it from to beupdated  (Dmitry O Litvintsev <litvinse@fnal.gov>)
Responses Re: [GENERAL] autovacuum holds exclusive lock on table preventing itfrom to be updated
List pgsql-general
Tree view 

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 by date:

Previous
From: Dmitry O Litvintsev
Date:
Subject: [GENERAL] autovacuum holds exclusive lock on table preventing it from to beupdated
Next
From: Bruce Momjian
Date:
Subject: Re: [GENERAL] pg_upgrade --link on Windows