Which Order Vacuum Full Analyze Cluster Reindex?
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?
"borajetta" <borajetta@hotmail.com> writes:
I am trying to firgure out what the best order is?
Vacuum Full table;
Cluster table;
Analyze table;
If you are going to CLUSTER then you can forget the VACUUM part
entirely. Just do CLUSTER and then ANALYZE.
regards, tom lane
Tom Lane <tgl@sss.pgh.pa.us> writes:
If you are going to CLUSTER then you can forget the VACUUM part
entirely. Just do CLUSTER and then ANALYZE.
Out of curiosity, does cluster also effectively do a reindex?
--
greg
Greg Stark <gsstark@mit.edu> writes:
Tom Lane <tgl@sss.pgh.pa.us> writes:
If you are going to CLUSTER then you can forget the VACUUM part
entirely. Just do CLUSTER and then ANALYZE.
Out of curiosity, does cluster also effectively do a reindex?
Yes, of course. It rewrites a whole new table and then rebuilds
the indexes.
regards, tom lane