[PERFORM] vacuum, analyze and reindex

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 -

Re: [PERFORM] vacuum, analyze and reindex

Centuries ago, Nostradamus foresaw when [EMAIL PROTECTED] (Javier Somoza) would write:     Hi all     I've a question about vacuuming, ...     Vacuum: cleans out obsolete and deleted registers...     Analyze:  update statistics for the planner