Search Postgresql Archives

Re: questions about wraparound

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Mon, Mar 29, 2021 at 7:12 PM Laurenz Albe <laurenz.albe@xxxxxxxxxxx> wrote:
> I didn't follow the rest of the thread, but autovacuum should handle
> those databases and advance their "datfrozenxid".

That did not happen.
In short: I turned off autovacuum globally, then in a database I
consumed a lot of xid while keeping a table locked. This produced a
wraparound in such database, but I was expecting emergency autovacuum
to keep other databases frozen. PostgreSQL 12.5.

Luca





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux