vacuum, analyze and reindex - Mailing list pgsql-performance

From Javier Somoza
Subject vacuum, analyze and reindex
Date
Msg-id 1141128665.1555.33.camel@pndsoft
Whole thread Raw
List pgsql-performance


            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

pgsql-performance by date:

Previous
From: Javier Somoza
Date:
Subject: Different disks for xlogs and data
Next
From: Christopher Browne
Date:
Subject: Re: vacuum, analyze and reindex