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. ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
