Browse categories
PostgreSQL releases
- PostgreSQL 14 (dev)
- PostgreSQL 13 (latest)
- PostgreSQL 12
- PostgreSQL 11
- PostgreSQL 10
- PostgreSQL 9.6
- PostgreSQL 9.5 (EOL)

Version charts

SQL commands
System catalog tables
System catalog views
System statistics views
File system functions

Progress reporting views
Contrib modules
Storage parameters (relopts)

Useful overviews

xlog renaming in Pg 10
Online tools for PostgreSQL

Useful links

PostgreSQL documentation
PostgreSQL feature matrix
PostgreSQL versioning policy
PostgreSQL latest versions

@postgrespedia

Contents

Change history
References
Categories
See also

REINDEX

A utility command for rebuilding indexes

REINDEX is a utility command for rebuilding indexes.

REINDEX was added in PostgreSQL 7.0.

Change history

PostgreSQL 14
- TABLESPACE clause added (commit c5b28604)
- support for partitioned tables and indexes added (commit a6642b3a)
PostgreSQL 12
- CONCURRENTLY option added (5dc92b84)
- progress of REINDEX can be tracked with pg_stat_progress_create_index (commit ab0dfc96)
PostgreSQL 9.5
- REINDEX SCHEMA ... option added (commit fe263d11)
- VERBOSE option added (commit ecd222e7)
PostgreSQL 8.1
- REINDEX SYSTEM option added (commit 4cc7a93d)
PostgreSQL 7.0
- added (commit e3a97b37)

References

PostgreSQL documentation: REINDEX

Categories

See also

reindexdb, CREATE INDEX, ALTER INDEX, DROP INDEX