Re: MultiXactId wraparound and last aggressive vacuum time

Поиск
Список
Период
Сортировка
От Michael Lewis
Тема Re: MultiXactId wraparound and last aggressive vacuum time
Дата
Msg-id CAHOFxGpjc7hVHi4tjK5bDP87FS+6SKAP2=dG72H6iywVB3abSQ@mail.gmail.com
обсуждение исходный текст
Ответ на MultiXactId wraparound and last aggressive vacuum time  (Michael Schanne <michael.schanne@gmail.com>)
Ответы Re: MultiXactId wraparound and last aggressive vacuum time
Список pgsql-general
I don't believe you can determine a date/time that it happened, but querying the age of the table is simple to do and then you can compare that with the freeze age parameters. A periodic manual vacuum freeze may preclude the system ever needing to perform the emergency autovacuum freeze, and as an added benefit, index only scans would be more likely to be chosen since the visibility map would be updated and the regular autovacuum runs would be faster since they can skip frozen pages. I think that applies back to 9.6 at least. It's possible it got implemented in 10.

My caffeine hasn't fully kicked in yet and I am still a bit junior on this list, but I would hope and expect senior people to correct me if I have misunderstood or misrepresented things.

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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: No enough privileges for autovacuum worker
Следующее
От: Андрей Сычёв
Дата:
Сообщение: Re: No enough privileges for autovacuum worker