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)
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.