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 ---------------------------(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
