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