adey wrote: > Hi Tom, > Further to my request below, the following recommendation exists in the > Postgres 8.1 documentation:- > http://www.postgresql.org/docs/8.1/interactive/routine-reindex.html Did you actually read that page? It says that there are some circumstances under which reindex is still required, but they should be rare. It doesn't have anything to do with page splits though. The problem is with page merging not being implemented (contiguous partially-filled pages are not merged) -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc.
