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.
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.