8.1.3 - autovacuum question

Поиск
Список
Период
Сортировка
От Chris Hoover
Тема 8.1.3 - autovacuum question
Дата
Msg-id 1d219a6f0606261338r52b14003vc384b1701718e38c@mail.gmail.com
обсуждение исходный текст
Ответы Re: 8.1.3 - autovacuum question  (Alvaro Herrera <alvherre@commandprompt.com>)
Re: 8.1.3 - autovacuum question  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
I turned on autovacuum on one of my database servers over the weekend.  I have been looking at the logs trying to see what it is doing.  However, all I see are lines like this:
,7674,,2006-06-26 16:31:37.650 EDT,,1,,,,LOG:  autovacuum: processing database "postgres"

Is there a way to tell if autovacuum is actually doing any work?  As far as I can see, it is running, but has not done any work.  Thanks for any help on tracking what autovacuum is doing.

Chris

В списке pgsql-admin по дате отправления:

Предыдущее
От: "Rodrigo Sakai"
Дата:
Сообщение: RES: Hiding table structure information
Следующее
От: "Benjamin Krajmalnik"
Дата:
Сообщение: Re: Using PostgreSQL and MIcrosoft SQLServer on the same server