Michael Monnerie wrote: > On Donnerstag 18 Dezember 2008 Guillaume Lelarge wrote: > > You should do a VACUUM and then a REINDEX. > > Thank you. And as I just learned about CLUSTER... would the correct > order be CLUSTER, VACUUM, REINDEX ? I guess so, as CLUSTER helps a lot > with cleaning up already, so there's less work for VACUUM/REINDEX. > Right?
You don't need to vacuum or reindex after a cluster; it removes all dead rows (except those that vacuum won't remove anyway)