[PERFORM] vacuum, analyze and reindex

[Javier Somoza]

            Hi all

            I've a question about vacuuming, ...

            Vacuum: cleans out obsolete and deleted registers...
            Analyze:  update statistics for the planner
            Reindex:  rebuild indexes

            I think the correct order to perform the database maintenance for performance is:

            1 - Vacuum
            2 - Reindex
            3 - Analyze

            So the planner is updated with the updated indexes.


            The autovacuum daemon does vacuum and analyze. Not reindex.
            So, no way to perform it in that order.

            What do you think?
            How often do you reindex your tables?

            Thx all