REINDEX SQL - Language Statements REINDEX Recover corrupted system indexes under standalone Postgres 2000-03-30 REINDEX { TABLE | DATABASE | INDEX } name [ FORCE ] 2000-03-30 TABLE Recreate all indexes of a specfied table. DATABASE Recreate all system indexes of a specfied database. INDEX Recreate a specfied 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 shutdown and standalone 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.