Postgres Pro
Downloads
Home   >   mailing lists

Re: Transaction ID wrap limit is log entries - Mailing list pgsql-admin

From Simon Riggs
Subject Re: Transaction ID wrap limit is log entries
Date
Msg-id CA+U5nMKfm0xrMgy_ND=1LKBrYUCC0bU_g_=V7m_Jpa8zDe=scg@mail.gmail.com
Whole thread Raw
In response to Transaction ID wrap limit is log entries  (Armand du Plessis <adp@bank.io>)
Responses Re: Transaction ID wrap limit is log entries  (Armand du Plessis <adp@bank.io>)
List pgsql-admin
Tree view 
On 19 May 2013 13:54, Armand du Plessis <adp@bank.io> wrote:

> We started seeing 1000s of messages like the ones below in our logs starting
> last night. There's been no changes but performance has dropped
> significantly.

> Any ideas what would be causing this?

The database has not been issuing VACUUMs on some or all of the
relations, so the system needs to issue "anti-transactional
wraparound" VACUUMs.

--
 Simon Riggs                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

pgsql-admin by date:

Previous
From: Armand du Plessis
Date:
Subject: Transaction ID wrap limit is log entries
Next
From: Armand du Plessis
Date:
Subject: Re: Transaction ID wrap limit is log entries