Re: Question regarding autovacuum in 8.1

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: Question regarding autovacuum in 8.1
Дата
Msg-id 20070830132824.GG5872@alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: Question regarding autovacuum in 8.1  (Denis Gasparin <denis@edistar.com>)
Список 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 по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Out of Memory - 8.2.4
Следующее
От: Günther Jedenastik
Дата:
Сообщение: why does a system catalog insert/update/delete not fire a trigger?