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)
Список
Дерево обсуждения
MultiXact member wraparound protections are disabled "AnandKumar, Karthik" <Karthik.AnandKumar@classmates.com>
Re: MultiXact member wraparound protections are disabled Alvaro Herrera <alvherre@2ndquadrant.com>
Re: MultiXact member wraparound protections are disabled "AnandKumar, Karthik" <Karthik.AnandKumar@classmates.com>
Re: MultiXact member wraparound protections are disabled Alvaro Herrera <alvherre@2ndquadrant.com>
Re: MultiXact member wraparound protections are disabled "AnandKumar, Karthik" <Karthik.AnandKumar@classmates.com>
Re: MultiXact member wraparound protections are disabled Alvaro Herrera <alvherre@2ndquadrant.com>
Re: MultiXact member wraparound protections are disabled avi Singh <avisingh19811981@gmail.com>
Re: MultiXact member wraparound protections are disabled Alvaro Herrera <alvherre@2ndquadrant.com>
Re: MultiXact member wraparound protections are disabled "AnandKumar, Karthik" <Karthik.AnandKumar@classmates.com>
Re: MultiXact member wraparound protections are disabled avi Singh <avisingh19811981@gmail.com>
Re: MultiXact member wraparound protections are disabled avi Singh <avisingh19811981@gmail.com>
Re: MultiXact member wraparound protections are disabled avi Singh <avisingh19811981@gmail.com>
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 auto vacuum 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 по дате отправления
