Robert Haas <robertmhaas@gmail.com> writes:
> Oh. So do the indexes just degrade over time until they eventually
> need to be REINDEX'd?
At some point you might reach a state where a reindex would be helpful.
But the same is true of btrees. I don't think this is a serious
objection, at least not unless backed by evidence that the tree often
degrades rapidly. Anyway fixing it would be material for a different
patch.
regards, tom lane