Postgres Pro
Downloads
Home   >   mailing lists

Which Order Vacuum Full Analyze Cluster Reindex? - Mailing list pgsql-general

From borajetta
Subject Which Order Vacuum Full Analyze Cluster Reindex?
Date
Msg-id BAY17-DAV8JkegVItwa00008ce0@hotmail.com
Whole thread Raw
Responses Re: Which Order Vacuum Full Analyze Cluster Reindex?
List pgsql-general
Tree view
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?

pgsql-general by date:

Previous
From: Tino Wildenhain
Date:
Subject: Re: Problem with sql COPY command
Next
From: "Marc G. Fournier"
Date:
Subject: Re: [OT?] Problems with majordomo :-)