Kevin Grittner wrote:
> 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
Ah, noted and updated, thank you.
Madi