Glossary: PostgreSQL Beyond the Basics
REINDEX
Also written: REINDEX INDEX CONCURRENTLY
A command that rebuilds an index that has bloated. With `CONCURRENTLY` it builds a fresh copy, swaps it in and drops the old one without blocking writes.
Glossary: PostgreSQL Beyond the Basics
Also written: REINDEX INDEX CONCURRENTLY
A command that rebuilds an index that has bloated. With `CONCURRENTLY` it builds a fresh copy, swaps it in and drops the old one without blocking writes.