Skip site navigation (1) Skip section navigation (2)

Re: Question regarding autovacuum in 8.1

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Denis Gasparin <denis(at)edistar(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Question regarding autovacuum in 8.1
Date: 2007-08-30 13:28:24
Message-ID: 20070830132824.GG5872@alvh.no-ip.org (view raw or flat)
Thread:
Lists: 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)

In response to

pgsql-general by date

Next:From: Günther JedenastikDate: 2007-08-30 13:30:49
Subject: why does a system catalog insert/update/delete not fire a trigger?
Previous:From: Alvaro HerreraDate: 2007-08-30 13:27:10
Subject: Re: Out of Memory - 8.2.4

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group