PostgreSQL

Скачать в pdf «PostgreSQL»

D.74 REINDEX


Name


REINDEX — Recover corrupted system indexes under stand-alone Postgres REINDEX { TABLE I DATABASE I 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 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.

d.75 RESET


Name


RESET — Restores run-time parameters for session to default values RESET variable


Inputs


variable Refer to SET for more information on available variables.


Outputs


RESET VARIABLE Message returned if variable is successfully reset to its default value. Description


RESET restores variables to their default values. Refer to SET for details on allowed values and defaults. RESET is an alternate form for SET variable = DEFAULT.

Скачать в pdf «PostgreSQL»