Vacuum, reindex, cluster, in propper order ?

Started by NTPTalmost 22 years ago1 messagesgeneral
Jump to latest
#1NTPT
ntpt@centrum.cz

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