dba:postgresql:postgresql_index_maintenance
This is an old revision of the document!
Table of Contents
PostgreSQL: Index maintenance quick guide
Official Index Maintenance guide
https://wiki.postgresql.org/wiki/Index_Maintenance
Quick conclusion: never EVER use VACUUM FULL
for index rebuild . It will break the indexes, if you use VACUUM FULL
you'll have to REINDEX
all the table indexes…
Index Bloat
dba/postgresql/postgresql_index_maintenance.1650611286.txt.gz · Last modified: 2022/04/22 07:08 by dodger