Rebuilds every index on the table from scratch, removing bloat and updating statistics. Plain REINDEX takes a lock that blocks writes; CONCURRENTLY avoids that but runs slower. Consider it after heavy deletes or a failed index build.
Looking for more? Search all 7,657 commands — works offline, in English or Spanish, and fixes typos.