Rebuild a problematic or bloated index.
Section: Maintenance tasks
PostgreSQL REINDEX
sql
sql
REINDEX INDEX idx_orders_user_id;Explanation
Use with care and pair with engine-specific operational guidance in production.
Learn the surrounding workflow
Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.
Related commands
Same sheet · prioritizing Maintenance tasks
SQLite VACUUM after major churn
Compact the file after heavy changes when appropriate.
Avoid duplicate or overlapping indexes
Do not keep several indexes that serve the same leading prefix needlessly.
Be careful with low-cardinality flags
A boolean by itself is often weak unless paired with something else or made partial.