On Sun, May 19, 2013 at 6:08 PM, Simon Riggs <simon@xxxxxxxxxxxxxxx> wrote:
On 19 May 2013 13:54, Armand du Plessis <adp@xxxxxxx> 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
