REINDEX() SQL Commands REINDEX()NAME
REINDEX - Recover corrupted system indexes under stand-alone Postgres
SYNOPSIS
REINDEX { TABLE | DATABASE | INDEX } name [ FORCE ]
INPUTS
TABLE Recreate all indexes of a specified table.
DATABASE
Recreate all system indexes of a specified database.
INDEX Recreate a specified index.
name The name of the specific table/database/index to be be rein‐
dexed.
FORCE Recreate indexes forcedly. Without this keyword REINDEX does
nothing unless target indexes are invalidated.
OUTPUTS
REINDEX
Message returned if the table is successfully reindexed.
DESCRIPTION
REINDEX is used to recover corrupted system indexes. In order to run
REINDEX command, postmaster must be shut down and stand-alone Postgres
should be started instead with options -O and -P (an option to ignore
system indexes). Note that we couldn't rely on system indexes for the
recovery of system indexes.
USAGE
Recreate the table mytable:
REINDEX TABLE mytable;
Some more examples:
REINDEX DATABASE my_database FORCE;
REINDEX INDEX my_index;
COMPATIBILITY
SQL92
There is no REINDEX in SQL92.
SQL - Language Statements 29 March 2001 REINDEX()