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:[EMAIL PROTECTED]
*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" <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
