Leonardo Francalanci <m_lists@xxxxxxxx> writes: >> I also recommend reindexing any table that has been VACUUM FULLed. > Mmmh, from the docs I get that in 9.0 a "vacuum full" rewrites the whole table, > so I expect the indexes to be re-created anyway... so a reindexing would > be totally useless. Any discussion of VACUUM FULL has to recognize that 9.0's implementation of it is completely different from all prior versions. It still has disadvantages, but not the ones that were there before. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
