Re: questions about wraparound

Поиск
Список
Период
Сортировка
От Luca Ferrari
Тема Re: questions about wraparound
Дата
Msg-id CAKoxK+6W5QgFNwbmv4TeWvQx9H_RadqmXW-XSPks6BM2v=OmwA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: questions about wraparound  (Laurenz Albe <laurenz.albe@cybertec.at>)
Список pgsql-general
Дерево обсуждения 
On Mon, Mar 29, 2021 at 7:12 PM Laurenz Albe <laurenz.albe@cybertec.at> 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

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

Предыдущее
От: Jagmohan Kaintura
Дата:
Сообщение: Re: PostgreSQL Views Where Clause Character Columns getting Typecasted to Text and Indexes not getting Used
Следующее
От: Don Seiler
Дата:
Сообщение: Re: Dangerous Naming Confusion