Обсуждение: Vacuum full and reindex

Поиск
Список
Период
Сортировка

Vacuum full and reindex

От
PG Doc comments form
Дата:
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/12/docguide.html
Description:

The documentation for vacuum FULL since 9.0 should mentioned that 
reindexing is included in the process.
For the moment, to get this information, we have to read
https://www.postgresql.org/docs/13/routine-vacuuming.html and find it buried
in the first tip : "you will need to use VACUUM FULL, or alternatively
CLUSTER or one of the table-rewriting variants of ALTER TABLE. These
commands rewrite an entire new copy of the table and build new indexes for
it"

Regards