| From: | Andreas Kretschmer <andreas(at)a-kretschmer(dot)de> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org,Dmitry O Litvintsev <litvinse(at)fnal(dot)gov>,"pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: autovacuum holds exclusive lock on table preventing it from to be updated |
| Date: | 2017-06-13 18:54:18 |
| Message-ID: | BC5D0E1A-62BB-4640-A430-2954C3020BEB@a-kretschmer.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Am 13. Juni 2017 20:04:04 MESZ schrieb Dmitry O Litvintsev <litvinse(at)fnal(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2017-06-13 20:07:48 | Re: [GENERAL] pg_upgrade --link on Windows |
| Previous Message | Dmitry O Litvintsev | 2017-06-13 18:04:04 | autovacuum holds exclusive lock on table preventing it from to be updated |