Топ-100
 
CerebroSQL

REINDEX

RDBMS Type: PostgreSQL
Topic

REINDEX { INDEX | TABLE | DATABASE | SYSTEM } name [ FORCE ]

Example

REINDEX INDEX my_index;
REINDEX TABLE my_table;

$ export PGOPTIONS="-P"
$ psql broken_db
...
broken_db=> REINDEX DATABASE broken_db;
broken_db=> \q