Madison Kelly <linux@alteeve.com> wrote:
> I've added CLUSTER -> ANALYZE -> VACUUM to my nightly
> routine and dropped the VACUUM FULL call.
The CLUSTER is probably not going to make much difference once
you've eliminated bloat, unless your queries do a lot of searches in
the sequence of the index used. Be sure to run VACUUM ANALYZE as
one statement, not two separate steps.
-Kevin