Re: autovacuum running even when not set in config? - Mailing list pgsql-admin

From Aldor
Subject Re: autovacuum running even when not set in config?
Date
Msg-id fk40j1$1vs5$1@news.hub.org
Whole thread Raw
In response to Re: autovacuum running even when not set in config?  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Responses Re: autovacuum running even when not set in config?  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-admin
Well, the database is also showing a hint when less then 9 million
transactions are available - and this hint is telling us to vacuum
the whole database.

If, vacuum the whole database, would take days (quite unsure how
many days sometimes) is it possible to find out manually which
tables originally need a vacuum or is the xid wraparound problem
database wide so we MUST vacuum the whole database?

The automatic startup of autovacuum in this cases is really good,
but we would like to manage vacuum by ourself, especially WHEN it is
running, because we have different load times on different database
servers depending on time zones and the users using it.

> It is normal if the database is in danger of Xid wraparound.  (So now
> you know have been neglecting to vacuum some tables).
>

pgsql-admin by date:

Previous
From: "gunartha"
Date:
Subject: Re: server error
Next
From: Pino Martínez Herbut
Date:
Subject: Ayuda Postgre