Vivek Khera wrote:
>
> On Aug 17, 2006, at 12:43 PM, Matthew T. O'Connor wrote:
>
> >Do you have row level stats enabled?
>
> is block level stats not sufficient for autovacuum?
>
> i'm seeing the same: "show all" tells me autovacuum is off, but it is
> for sure turned on in the postgresql.conf file and block level stats
> are on, but row level are not.
The server emitted a warning when the postmaster started because it
turned off autovacuum because row-level stats were off. So yeah,
block-level stats are not sufficient.
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support