Robert Haas <robertmh...@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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers