Ciberterminal Wiki

User Tools

Site Tools

Trace:
dba:postgresql:postgresql_index_maintenance

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
dba:postgresql:postgresql_index_maintenance [2022/04/22 07:08] – dodgerdba:postgresql:postgresql_index_maintenance [2022/04/22 07:09] (current) – dodger
Line 5: Line 5:
  
  
-Quick conclusion: never *EVER* use ''VACUUM FULL'' for index rebuild LOL. It will break the indexes, if you use ''VACUUM FULL'' you'll have to ''REINDEX'' all the table indexes...+Quick conclusion: never **EVER** use ''VACUUM FULL'' for index rebuild LOL. It will break the indexes, if you use ''VACUUM FULL'' you'll have to ''REINDEX'' all the table indexes...
  
 ====== Index Bloat ====== ====== Index Bloat ======
dba/postgresql/postgresql_index_maintenance.txt · Last modified: 2022/04/22 07:09 by dodger