Re: Question regarding autovacuum in 8.1 - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Question regarding autovacuum in 8.1
Date
Msg-id 20070830132824.GG5872@alvh.no-ip.org
Whole thread Raw
In response to Re: Question regarding autovacuum in 8.1  (Denis Gasparin <denis@edistar.com>)
List pgsql-general
Denis Gasparin wrote:

> Another question/idea: why don't put messages about what tables got
> vacuumed by the autovacuum daemon as normal log messages (instead of
> debug2)?

We did that for 8.3, actually.

> I think it could be useful because in this way you can also know what
> tables are used more often then other...

Well, if you want to know which tables are used more, check the pg_stat
views.

--
Alvaro Herrera                 http://www.amazon.com/gp/registry/DXLWNGRJD34J
"No hay cielo posible sin hundir nuestras raíces
 en la profundidad de la tierra"                        (Malucha Pinto)

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Out of Memory - 8.2.4
Next
From: Günther Jedenastik
Date:
Subject: why does a system catalog insert/update/delete not fire a trigger?