Re: How can I tell if I'm autovacuuming?

Поиск
Список
Период
Сортировка
От Ireneusz Pluta
Тема Re: How can I tell if I'm autovacuuming?
Дата
Msg-id 4BFBC336.1010709@wp.pl
обсуждение исходный текст
Ответ на Re: How can I tell if I'm autovacuuming?  ("Joshua D. Drake" <jd@commandprompt.com>)
Список pgsql-admin
Дерево обсуждения 
>> (b) How can I verify that my databases are being vacuumed by autovacuum?
>>
>
> pg_stat_user_tables should have a last_autovac column.
>
Also, you can see autovacuum related messages like:

DEBUG:  autovacuum: processing database "postgres"
DEBUG:  autovacuum: processing database "template1"

in your server log, by setting log_min_messages to 'debug1' in your
postgresql.conf.
As a side effect you may also see some other messages enabled with the
same debug level,

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

Предыдущее
От: Khangelani Gama
Дата:
Сообщение: Quickest command to dump and restore the database? : pg_dump and pg_restore? using PostgreSQL 8.3 running on RedHat 5.3
Следующее
От: Ian Lea
Дата:
Сообщение: Re: Quickest command to dump and restore the database? : pg_dump and pg_restore? using PostgreSQL 8.3 running on RedHat 5.3