Name
REINDEX -- Rebuilds indices on tables.
Synopsis
REINDEX { TABLE | DATABASE | INDEX }
name
[ FORCE ]
Parameters
-
TABLE | DATABASE | INDEX
-
The type of database object to be re-indexed.
-
name
-
The name of the database object you wish to re-index.
-
FORCE
-
The FORCE keyword forces the rebuilding of all specified indices. If this parameter is not given, the REINDEX command will rebuild only invalidated indices.
Results
-
REINDEX
-
The message returned when a target object is successfully reindexed.
Description
Use the REINDEX command to rebuild any indices that have become corrupt. This is especially useful if system indices become corrupted. To fix them, shutdown
postmaster
and start it using the
-o "-O -P"
command-line parameter. This opens a standalone server that allows for re-indexing of system indices. Run the REINDEX DATABASE command once you are at the
psql
prompt.
Examples
The following example rebuilds all indices on the books table, within the booktown database:
booktown=#
REINDEX TABLE books;
REINDEX
