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.