REINDEX SQL - Language Statements REINDEX Recover corrupted system indexes under stand-alone Postgres 2000-03-30 REINDEX { TABLE | DATABASE | INDEX } name [ FORCE ] 2000-03-30 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. 2000-03-30 REINDEX Message returned if the table is successfully reindexed. 2000-03-30 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. Recreate the table mytable: REINDEX TABLE mytable; Some more examples: REINDEX DATABASE my_database FORCE; REINDEX INDEX my_index; 2000-03-30 There is no REINDEX in SQL92.