Re: autovac state persistence

From: "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>
To: "Ed L(dot)" <pgsql(at)bluepolka(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: autovac state persistence
Date: 2006-11-15 06:51:32
Message-ID: 455AB8F4.3080603@zeut.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ed L. 2006-11-15 06:53:50 Re: autovac state persistence
Previous Message Ed L. 2006-11-15 05:23:41 Re: autovac hung/blocked