On Tue, Nov 16, 2010 at 3:46 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> 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.
Oh, I agree it's not for this patch to fix it, if it's already that
way. I was just curious. I think index maintenance is going to be a
problem we have to devote some cycles to down the road, though.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company