dba:postgresql:postgresql_index_maintenance
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.txt · Last modified: 2022/04/22 07:09 by dodger