|PostgreSQL 7.4.30 Documentation|
|Prev||Fast Backward||Chapter 21. Routine Database Maintenance Tasks||Fast Forward||Next|
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.