pgPedia

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

Top / R

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

Useful articles

System catalog tables
System catalog views
System statistics views
Progress reporting views

Contrib modules
Storage parameters (relopts)

xlog renaming in Pg 10

Useful links

PostgreSQL documentation
PostgreSQL feature matrix
PostgreSQL versioning policy
PostgreSQL latest versions

explain.depesz.com/

REINDEX

REINDEX is a DDL command for rebuilding indexes.

REINDEX was added in PostgreSQL 7.0.

Change history

• PostgreSQL 14
  • support for partitioned tables and indexes added (commit a6642b3a)
• PostgreSQL 12
  • CONCURRENTLY option added (5dc92b84)
• 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

Categories

See also