Postgres Pro
Downloads
Home   >   mailing lists

Re: btree split logic is fragile in the presence of lar ge index items - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: btree split logic is fragile in the presence of lar ge index items
Date
Msg-id 200007270327.XAA12355@candle.pha.pa.us
Whole thread Raw
In response to RE: btree split logic is fragile in the presence of lar ge index items  ("Mikheev, Vadim" <vmikheev@SECTORBASE.COM>)
List pgsql-hackers
Tree view 
> Note that using TID as part of key would give us additional feature:
> fast heap tuple --> index tuple look up. With this feature vacuum wouldn't
> have to read entire index to delete a few items... and this will be required
> for space re-using without vacuum...

Wow, this seems like a huge win.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Warnings triggered by recent includefile cleanups
Next
From: Bruce Momjian
Date:
Subject: Re: The query cache - first snapshot (long)