On Tue, Nov 16, 2010 at 1:50 PM, Heikki Linnakangas <heikki.linnakan...@enterprisedb.com> wrote: >> If we start to enlarge the bounding boxes on the higher levels of the >> tree and then crash before inserting the key, is there any mechanism >> for getting them back down to the minimal size? > > No. There's also no mechanism for trimming the bounding boxes if a tuple is > deleted.
Oh. So do the indexes just degrade over time until they eventually need to be REINDEX'd? -- 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
