Re: Analyze and vacuum, they are sort of mandatory....

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/