Re: Autovacuum progressing slow (with high activity on the system).

From: Kevin Grittner <kgrittn(at)ymail(dot)com>
To: "jesper(at)krogh(dot)cc" <jesper(at)krogh(dot)cc>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Autovacuum progressing slow (with high activity on the system).
Date: 2014-02-28 21:39:40
Message-ID: 1393623580.65625.YahooMailNeo@web122303.mail.ne1.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"jesper(at)krogh(dot)cc" <jesper(at)krogh(dot)cc> wrote:

> The database is a large database (3TB+) and I have 200+ backend
> processes polling a message queuetable for work to do. On this message
> queue table, when activity rises autovacuum fails to make progress and I
> cannot get what is actually holding it back

What version is this, as shown by the version() function?

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Campbell, Lance 2014-03-04 14:49:32 Enhancement Request
Previous Message Amardeep Kaur 2014-02-27 12:53:58 Re: Increasing maximum connection for postgresql 9.2