| From: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
|---|---|
| To: | "Pavlov, Vladimir" <Vladimir(dot)Pavlov(at)tns-global(dot)ru> |
| Cc: | "'pgsql-admin(at)postgresql(dot)org'" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: MultiXact member wraparound protections |
| Date: | 2016-03-30 21:46:50 |
| Message-ID: | 20160330214650.GA48839@alvherre.pgsql |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Pavlov, Vladimir wrote:
> Hello,
> The server logs contain errors:
> MultiXact member wraparound protections are disabled because oldest checkpointed MultiXact 1085772411 does not exist on disk
> How to enable MultiXact member wraparound protection?
As I understand it, autovacuum should be processing all the tables in
order to establish a safe multixact. Have a look at the autovacuum
activity in the server.
--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Asad Shah | 2016-03-31 19:06:15 | Re: primary key size is huge |
| Previous Message | Alvaro Aguayo Garcia-Rada | 2016-03-30 20:52:00 | Re: primary key size is huge |