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 reindexed.
FORCE Recreate indexes forcedly. Without this keyword
REINDEX does nothing unless target indexes are
invalidated.
OUTPUTS
REINDEX
Message returned if the table is successfully rein
dexed.
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;
SQL92
There is no REINDEX in SQL92.
Man(1) output converted with
man2html