Re: 8.2.3 AutoVacuum not running

OK, do you have the stats system enabled also?  You require at least
row_level stats for autovacuum to work.


Schwenker, Stephen wrote:
> I'm sure.  That column is null for all tables in my databases accept for
> the few tables that I've vacuumed manually.
>
> Any other suggestions?  :)
>
> ------------------------------------------------------------------------
> *From:* Tom Lane [mailto:tgl@sss.pgh.pa.us]
> *Sent:* Fri 06/04/2007 1:21 PM
> *To:* Schwenker, Stephen
> *Cc:* pgsql-general@postgresql.org
> *Subject:* Re: [GENERAL] 8.2.3 AutoVacuum not running
>
> "Schwenker, Stephen" <SSchwenker@thestar.ca> writes:
>  > I've just compiled an instance of Postgresql 8.2.3 on a new linux box
>  > and have added some databases to it.  I've noticed however that the
>  > autovacuum is not running.
>
> How sure are you of that?  Check pg_stat_all_tables to see if the
> last_autovacuum column is changing.
>
>                         regards, tom lane
>