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.