Jim C. Nasby wrote:
> On Tue, Aug 22, 2006 at 11:08:49AM -0400, Tom Lane wrote:
>> "Jim C. Nasby" <[EMAIL PROTECTED]> writes:
>>> If there's a bunch of activity on a table but stats are reset
>>> before a vacuum is run on it and then a vacuum is run, the user
>>> will still be left thinking that the table needs to be vacuumed.
>> Except that autovac *won't* vacuum it if the stats have been reset.
>> So I'm not seeing that there's really a problem in practice.
> IIRC the stats also include info about regular (manual) vacuums, so
> the above scenario still applies.

They do.  The stats patch as applied captures both autovacuum and manual
as well as analyze (both from the Autovacuum daemon and manual).

Larry Rosenman                     http://www.lerctr.org/~ler
Phone: +1 512-248-2683                 E-Mail: ler@lerctr.org
US Mail: 430 Valona Loop, Round Rock, TX 78681-3893

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?


Reply via email to