Jim,
> Upsizes? Are you adding more data? If so then yes, analyze would be
> good, though autovacuum should handle it for you.
I create new Postgres database, upsize a lot of data into it. After that
this database goes online and will receive a lot of transactions daily.
I'm using PG 8.1 default postgres.conf file.
I read than autovacuum may skip some tables which can cause wrong guru
hints.
So it seems that I should run manually VACUUM ANALYZE for the whole database
once for initial statistics colection of those tables, isn't it?
Andrus.