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. -- Sent via pgsql-admin mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
