The section "Routine Reindexing" (21.2) has been reduced to:
"""
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.
"""
Can someone add something that is of substantial value and less hand-wavy?
--
Peter Eisentraut peter_e@gmx.net