Re: autovac state persistence - Mailing list pgsql-general

From Matthew T. O'Connor
Subject Re: autovac state persistence
Date
Msg-id 455AB8F4.3080603@zeut.net
Whole thread Raw
In response to autovac state persistence  ("Ed L." <pgsql@bluepolka.net>)
Responses Re: autovac state persistence  ("Ed L." <pgsql@bluepolka.net>)
List pgsql-general
Ed L. wrote:
> Does autovac maintain its state/counters across restats as to who
> need to be vacuumed/analyzed?  Or does killing autovac cause it
> to reset the counters for the vacuum/analyze threshholds?

Depends on the version.  The contrib autovacuum does not maintain state
through a restart.  The integrated version (8.0 and 8.1) can maintain
state as long as you don't have the stat system configured to reset on
restart.

Matt


pgsql-general by date:

Previous
From: "Ed L."
Date:
Subject: Re: autovac hung/blocked
Next
From: "Ed L."
Date:
Subject: Re: autovac state persistence