Kevin Grittner wrote:
Madison Kelly <linux@xxxxxxxxxxx> 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
--
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
