| From: | PG Doc comments form <noreply(at)postgresql(dot)org> |
|---|---|
| To: | pgsql-docs(at)lists(dot)postgresql(dot)org |
| Cc: | gparc(at)online(dot)fr |
| Subject: | Vacuum full and reindex |
| Date: | 2021-05-31 07:31:23 |
| Message-ID: | 162244628359.9361.6826337722483866341@wrigleys.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2021-06-01 06:58:26 | Simplify COMMENT and SECURITY LABEL documentation |
| Previous Message | Laurenz Albe | 2021-05-31 05:42:46 | Re: Note that ALTER TABLE cannot alter generated stored columns |