Postgres Pro
Downloads
Home   >   mailing lists

Re: MultiXact member wraparound protections - Mailing list pgsql-admin

From Alvaro Herrera
Subject Re: MultiXact member wraparound protections
Date
Msg-id 20160330214650.GA48839@alvherre.pgsql
Whole thread Raw
In response to MultiXact member wraparound protections  ("Pavlov, Vladimir" <Vladimir.Pavlov@tns-global.ru>)
List pgsql-admin
Tree view 
Pavlov, Vladimir wrote:
> Hello,
> The server logs contain errors:
> MultiXact member wraparound protections are disabled because oldest checkpointed MultiXact 1085772411 does not exist
ondisk 
> 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

pgsql-admin by date:

Previous
From: Alvaro Aguayo Garcia-Rada
Date:
Subject: Re: primary key size is huge
Next
From: Asad Shah
Date:
Subject: Re: primary key size is huge