Mark Woodward wrote:
> My question was based on an observation that ANALYZE and VACUUM are
> nessisary, both for different reasons. The system or tools must be
> able to detect substantial changes in the database and at least run
> analyze if failing to do so would cause PostgreSQL to fail badly.
Yes, that is what autovacuum does. It detects changes in the database
and runs analyze if failing to do so would cause PostgreSQL to behave
badly. I don't know why it's not turned on by default. You could
argue about that. But I don't know what else you are looking for.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/