On Tue, Nov 16, 2010 at 3:46 PM, Tom Lane <t...@sss.pgh.pa.us> wrote: > 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.
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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
