Re: autovacuum daemon question...

Поиск
Список
Период
Сортировка
От Matthew T. O'Connor
Тема Re: autovacuum daemon question...
Дата
Msg-id 4373B07F.5040706@zeut.net
обсуждение исходный текст
Ответ на Re: autovacuum daemon question...  (Jeff Bohmer <jdblist@visionlink.org>)
Ответы Re: autovacuum daemon question...  (Jeff Bohmer <jdblist@visionlink.org>)
Список pgsql-admin
Jeff Bohmer wrote:
>> I assumed (perhaps incorrectly) that you were talking about
>> maintaining  the data in the theoretical / not yet in existence
>> autovacuum stats table through database restart, the stats system
>> already has a GUC var that dictates whether or not it dumps it's data
>> upon DB restart.
> AFAIK, a restart does not affect the VACUUMed-ness of anything.
> Keeping these (currently nonexistent autovacuum) stats across restarts
> would be helpful if stats_reset_on_server_start=on.
>
> Unless I misunderstand, if stats_reset_on_server_start=off, these
> (currently nonexistent autovacuum) stats would only be relevant for
> autovacuum's VACUUM activity and not it's ANALYZE activity.  In which
> case, it seems ideal to keep autovacuum VACUUM stats regardless of the
> GUC setting, while autovacuum ANALYZE stats should follow it. But if
> the ideal is impractical, making both ANALYZE and VACUUM stats follow
> the GUC would still be real nice.

I'm confused...  the GUC var stats_reset_on_server_start dictates if the
stats system dumps its data on DB restart.  If we added a new table to
the stats system kept track of autovacuum activity, then that data would
also be dumped on restart if stats_reset_on_server_start=true.



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

Предыдущее
От: FM
Дата:
Сообщение: backup restore of DB + LO
Следующее
От: Jeff Bohmer
Дата:
Сообщение: Re: autovacuum daemon question...