Re: A thought on Index Organized Tables - Mailing list pgsql-hackers

From Gokulakannan Somasundaram
Subject Re: A thought on Index Organized Tables
Date
Msg-id [email protected]
Whole thread Raw
In response to Re: A thought on Index Organized Tables  (Tom Lane <[email protected]>)
List pgsql-hackers


On Wed, Feb 24, 2010 at 10:09 PM, Tom Lane <[email protected]> wrote:
"Kevin Grittner" <[email protected]> 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.

pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Re: pg_stop_backup does not complete
Next
From: Heikki Linnakangas
Date:
Subject: Re: pg_stop_backup does not complete