Re: Autovacuum daemon internal handling

Поиск
Список
Период
Сортировка
От Gnanakumar
Тема Re: Autovacuum daemon internal handling
Дата
Msg-id 002401cb39da$bf04aec0$3d0e0c40$@com
обсуждение исходный текст
Ответ на Re: Autovacuum daemon internal handling  (Alvaro Herrera <alvherre@commandprompt.com>)
Ответы Re: Autovacuum daemon internal handling  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-admin
> in 8.2 "naptime" means "time to sleep after we finish a job".  So even
> if the previous task takes an hour, it will still sleep a minute before
> doing another round.  (Note that this setting has a different meaning in
> later releases).

I couldn’t understand the difference in meaning of "autovacuum_naptime" between 8.2 and later releases from the
documentation. May be I'm not understanding/seeing the subtle difference in the documentation lines mentioned.  I
referredthese 3 doc links: 
http://www.postgresql.org/docs/8.2/interactive/runtime-config-autovacuum.html
http://www.postgresql.org/docs/8.3/interactive/runtime-config-autovacuum.html
http://www.postgresql.org/docs/8.4/interactive/runtime-config-autovacuum.html

8.2 doc says "Specifies the delay between activity rounds for the autovacuum daemon...."
8.3 & 8.4 doc says "Specifies the minimum delay between autovacuum runs on any given database....."

Can you please make me clear on this?

> If autovacuum cannot keep up with all the vacuumable tables, you're in
> trouble and should probably schedule vacuum externally.  (This also
> changed in later releases).

Can you please point me to relevant documentation links on this change?

>> 2. The columns "last_autovaccum" and 'last_autoanalyze" in
>> pg_stat_user_tables shows the start time or end time of the operation?

> End time.
Is there any way to find out the start time of "last_autovaccum" and/or 'last_autoanalyze" for a given table in 8.2.3?
Sothat I can isolate the tables that are taking too long time to complete vacuum and/or analyze and I can perform them
externallyif need. 



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: how do i query the type of an object?
Следующее
От: Yeb Havinga
Дата:
Сообщение: Re: how do i query the type of an object?