↑↓ select ↵ open ⌫ change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Supported versions: Current (18) / 17 / 16 / 15 / 14
Development versions: 19 / devel
Unsupported versions: 13 / 12 / 11 / 10 / 9.6 / 9.5 / 9.4 / 9.3 / 9.2 / 9.1 / 9.0 / 8.4 / 8.3 / 8.2 / 8.1 / 8.0 / 7.4 / 7.3
Historical version. PostgreSQL 8.0 reached end of support in October 2010. See the current version for supported releases.
PostgreSQL 8.0.26 Documentation
Prev Fast Backward Chapter 21. Routine Database Maintenance Tasks Fast Forward Next

21.2. Routine Reindexing

In some situations it is worthwhile to rebuild indexes periodically with the REINDEX command. (There is also contrib/reindexdb which can reindex an entire database.) However, PostgreSQL 7.4 has substantially reduced the need for this activity compared to earlier releases.

Prev Home Next
Routine Database Maintenance Tasks Up Log File Maintenance

Report a documentation issue

Read the upstream documentation. For corrections, first check the current version.