PostgreSQLmedium

What does `REINDEX` do and when would you use it?

Answer

`REINDEX` rebuilds indexes. You use it when an index is bloated or suspected corrupted, or after certain operations where rebuilding helps performance. It can take locks and consume resources, so plan it.

Related questions

PostgreSQL

BRIN index: when is it useful?

#postgres#brin#indexes

PostgreSQL

GIN vs GiST indexes: when would you use each?

#postgres#indexes#gin

PostgreSQL

Autovacuum: when does it run and why does it matter?

#postgres#autovacuum#stats

PostgreSQL

VACUUM vs VACUUM FULL: what’s the difference?

#postgres#vacuum#maintenance

PostgreSQL

HOT updates and `fillfactor`: what are they and why can they help?

#postgres#hot-update#fillfactor

PostgreSQL

What is VACUUM/autovacuum and why is it important?

#vacuum#autovacuum#maintenance