Leonardo F escribió: > > VACUUM ANALYZE; > > CLUSTER; > > REINDEX DATABASE "database"; > > ANALYZE has to go after CLUSTER; and CLUSTER already > vacuums the tables (I'm not 100% sure though). CLUSTER also > reindexes the whole table, so there's no need for another REINDEX. > > I think the right way of doing it would be: > > CLUSTER; > ANALYZE; (no "vacuum analyze", just "analyze").
Note that cluster only clusters tables that have been previously clustered. So you still need to vacuum tables that are not clustered. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
