Thread: Vacuum, reindex, cluster, in propper order ?

Vacuum, reindex, cluster, in propper order ?

From
"NTPT"
Date:
Hi. I need to  do some routine maintance task drived by crontab. It  is vacuuming, reindexing an clustering for faster access.
 
 
 So I need to ask, what order of  commands is correct for best performance and low maintance window  ?  I do not found any word of it in the documentation. i use pg 7.3.2 
 
 
1: vacuuum full analyze
2: reindex table foo (and other tables)
3: cluster table foo (and other tables) on indexname 
4:  vacuum analyze
 
thanx for help