From: Kevin Grittner <kgrittn@ymail.com>
To: jesper@krogh.cc <jesper@krogh.cc>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Autovacuum progressing slow (with high activity on the system).
Date: Fri, 28 Feb 2014 13:39:40 -0800 (PST)
Message-ID: <1393623580.65625.YahooMailNeo@web122303.mail.ne1.yahoo.com> (raw)
In-Reply-To: <f279e42bf733a46d8031b42a8dbcdc15.squirrel@shrek.krogh.cc>
References: <f279e42bf733a46d8031b42a8dbcdc15.squirrel@shrek.krogh.cc>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
"jesper@krogh.cc" <jesper@krogh.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
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: kgrittn@ymail.com, jesper@krogh.cc
Subject: Re: Autovacuum progressing slow (with high activity on the system).
In-Reply-To: <1393623580.65625.YahooMailNeo@web122303.mail.ne1.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox