Postgres Pro
Downloads
Home   >   mailing lists

Thread: autovac state persistence

autovac state persistence

From
"Ed L."
Date:
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?

TIA.
Ed

Re: autovac state persistence

From
"Matthew T. O'Connor"
Date:
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

Re: autovac state persistence

From
"Ed L."
Date:
On Tuesday November 14 2006 11:51 pm, Matthew T. O'Connor wrote:
> 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.

I'm talking about 8.1.2, thanks.

Ed