Re: Transaction ID wrap limit is log entries

On Sun, May 19, 2013 at 6:08 PM, Simon Riggs <simon(at)2ndquadrant(dot)com> wrote:

> On 19 May 2013 13:54, Armand du Plessis <adp(at)bank(dot)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.
>

Thanks, once I logged in with another user I saw there's one relation that
is being vacuumed to prevent tx wraparound. The sheer number of those log
entries made it seem like the autovacuum is in a loop.

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