"Mark Coffman" <mark@epilogue.net> writes:
> I do a
> VACUUM
> VACUUM ANALYZE
> every hour... it takes about 3 minutes to run both. Should I run ANALYZE
> less often?
VACUUM ANALYZE is a superset of VACUUM; there's certainly no reason to
do both one after the other.
As to whether you should do plain VACUUM some hours and VACUUM ANALYZE
others, that depends --- how fast are the statistics of your data
changing? If the stats (such as column minimum and maximum values) are
relatively stable, you could get away with fewer ANALYZEs. Maybe do one
ANALYZE every night at an off-peak time, and just plain VACUUM the rest
of the day.
regards, tom lane
