Postgres Pro
Downloads
Home   >   mailing lists

Re: Autovacuum progressing slow (with high activity on the system). - Mailing list pgsql-admin

From Kevin Grittner
Subject Re: Autovacuum progressing slow (with high activity on the system).
Date
Msg-id 1393623580.65625.YahooMailNeo@web122303.mail.ne1.yahoo.com
Whole thread Raw
In response to Autovacuum progressing slow (with high activity on the system).  (jesper@krogh.cc)
List pgsql-admin
Tree view 
"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

pgsql-admin by date:

Previous
From: Amardeep Kaur
Date:
Subject: Re: Increasing maximum connection for postgresql 9.2
Next
From: "Campbell, Lance"
Date:
Subject: Enhancement Request