| From: | "AnandKumar, Karthik" <Karthik(dot)AnandKumar(at)classmates(dot)com> |
|---|---|
| To: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, avi Singh <avisingh19811981(at)gmail(dot)com> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: MultiXact member wraparound protections are disabled |
| Date: | 2016-10-14 01:34:55 |
| Message-ID: | 292A3584-86CE-4CF3-8B4F-9703439BBB64@classmates.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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 auto vacuum activity as well.
It looks like it bumped up the oldest multitxid to something other than 1 now:
postgres(at)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jaisingkar, Piyush | 2016-10-14 06:52:30 | Re: Passing of where clause to remote table in FDW |
| Previous Message | Adrian Klaver | 2016-10-14 00:18:54 | Re: Issue with installation of postgresql server |