Which Order Vacuum Full Analyze Cluster Reindex?

From: "borajetta" <borajetta(at)hotmail(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Which Order Vacuum Full Analyze Cluster Reindex?
Date: 2004-08-27 18:40:53
Message-ID: BAY17-DAV8JkegVItwa00008ce0@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I am trying to firgure out what the best order is?

I was thinking

Vacuum Full table;
Cluster table;
Analyze table;

I belive the vacuum full should be done first as it will remove the rows where no data exits so that when it is clustered it will be a perfect table, then analyze to build the info for the table.

Also where should the reindex's come in and should they be done?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-08-27 18:43:45 Re: performance of IN (subquery)
Previous Message Tom Lane 2004-08-27 18:25:05 Re: Strange difference in query execution time