| From: | Javier Somoza <jsomoza(at)pandasoftware(dot)es> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | vacuum, analyze and reindex |
| Date: | 2006-02-28 12:11:05 |
| Message-ID: | 1141128665.1555.33.camel@pndsoft |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christopher Browne | 2006-02-28 13:34:01 | Re: vacuum, analyze and reindex |
| Previous Message | Javier Somoza | 2006-02-28 09:45:45 | Different disks for xlogs and data |