Re: MultiXact member wraparound protections are disabled

Поиск
Список
Период
Сортировка
От AnandKumar, Karthik
Тема Re: MultiXact member wraparound protections are disabled
Дата
Msg-id 292A3584-86CE-4CF3-8B4F-9703439BBB64@classmates.com
обсуждение исходный текст
Ответ на Re: MultiXact member wraparound protections are disabled  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Список pgsql-general
Thank you for your help Alvaro - we really appreciate it.
The error in fact stopped this morning - we took downtime and ran a vacuum across all of our tables, and saw increased
autovacuum activity as well.
 

It looks like it bumped up the oldest multitxid to something other than 1 now:

postgres@site-db01a:~ $ /usr/pgsql-9.4/bin/pg_controldata /var/lib/pgsql/cmates/data | grep -i multi 
Latest checkpoint's NextMultiXactId: 785051 
Latest checkpoint's NextMultiOffset: 1446371 
Latest checkpoint's oldestMultiXid: 575211 
Latest checkpoint's oldestMulti's DB: 12998


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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Issue with installation of postgresql server
Следующее
От: "Jaisingkar, Piyush"
Дата:
Сообщение: Re: Passing of where clause to remote table in FDW