rebuild indexes NAME REINDEX - rebuild indexes SYNOPSIS REINDEX [ ( option [, ...] ) ] { INDEX | TABLE | SCHEMA } [ CO......tely by this command; depending on the parameter you might need to rebuild the index with REINDEX to get the desired effects. RESET ( storage_parameter [, ... ] ) This form rese…...his happens, all objects depending on the collation should be rebuilt, for example, using REINDEX . When that is done, the collation version can be refreshed using the command A…...to perform CREATE INDEX CONCURRENTLY . (Another possibility is to rebuild the index with REINDEX INDEX CONCURRENTLY ). Another caveat when building a unique index concurrently i…...NTLY before dropping the index being replaced. Warning While CREATE INDEX CONCURRENTLY or REINDEX CONCURRENTLY is running on a unique index, INSERT ... ON CONFLICT statements on…