Re: Autovacuum on by default?

From: "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Jim C(dot) Nasby" <jim(at)nasby(dot)net>, Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Autovacuum on by default?
Date: 2006-08-23 07:24:21
Message-ID: 20060823072421.GJ88878@pervasive.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Aug 22, 2006 at 11:08:49AM -0400, Tom Lane wrote:
> "Jim C. Nasby" <jim(at)nasby(dot)net> 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.
--
Jim C. Nasby, Sr. Engineering Consultant jnasby(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jim C. Nasby 2006-08-23 07:26:27 Re: Autovacuum on by default?
Previous Message Dave Page 2006-08-23 07:14:47 Re: Problem with mailing list?