Browse categories
Random entry
Blog
PostgreSQL releases
- PostgreSQL 16 (dev)
- PostgreSQL 15 (latest)
- PostgreSQL 14
- PostgreSQL 13
- PostgreSQL 12
- PostgreSQL 11
- PostgreSQL 10 (EOL)

Version charts

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

Contrib modules
Object Identifier Types
Progress reporting views
Storage parameters (relopts)
Predefined roles

Useful overviews

xlog renaming in Pg 10
Online tools for PostgreSQL
Abbreviations and acronyms

Useful links

PostgreSQL documentation
PostgreSQL feature matrix
PostgreSQL versioning policy
PostgreSQL latest versions

@postgrespedia

Contents

Change history
References
Categories
See also

reindexdb

A utility for reindexing a running database

reindexdb is a core utility for reindexing a running database.

reindexdb was added (as a contrib module) in PostgreSQL 7.3.

Change history

PostgreSQL 14
- option --tablespace added (commit 57e6db70)
PostgreSQL 13
- option --jobs added (commit 5ab892c3)
PostgreSQL 12
- option --concurrently added (commit 5dc92b84)
PostgreSQL 9.5
- option --verbose added (commit 458a0770)
- option --schema added (commit fe263d11)
PostgreSQL 9.3
- option -t/--table can be provided multiple times (commit f3af5344)
PostgreSQL 9.2
- --maintenance-db option added (commit 68281e00)
PostgreSQL 8.4
- -w/--no-password option added (commit 9de59fd1)
PostgreSQL 8.3
- Ctrl-C interrupt handler added (commit 6e09df9d)
PostgreSQL 8.1
- converted to a core utility (commit 85e9a5a0)
PostgreSQL 7.3
- added (as a contrib module; commit 485fc354)

References

PostgreSQL documentation: reindexdb

Categories

See also

REINDEX, clusterdb, vacuumdb