On Wed, Feb 24, 2010 at 10:09 PM, Tom Lane <t...@sss.pgh.pa.us> wrote:
> "Kevin Grittner" <kevin.gritt...@wicourts.gov> writes: > > So you are essentially proposing that rather than moving the heap > > data into the leaf tuples of the index in the index file, you will > > move the leaf index data into the heap tuples? The pages in such a > > IOT heap file would still need to look a lot like index pages, yes? > > > I'm not saying it's a bad idea, but I'm curious what benefits you > > see to taking that approach. > > Isn't that just a variant on Heikki's "grouped index tuples" idea? > > regards, tom lane > No Tom, Grouped index tuple doesn't use the B+ Tree data structure to achieve the sorting, so it will not guarantee 100% clustering of data. Gokul.
