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

From Tom Lane
Subject Re: A thought on Index Organized Tables
Date
Msg-id 8773.1267029560@sss.pgh.pa.us
Whole thread Raw
In response to Re: A thought on Index Organized Tables  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Responses Re: A thought on Index Organized Tables
Re: A thought on Index Organized Tables
List pgsql-hackers
"Kevin Grittner" <Kevin.Grittner@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


pgsql-hackers by date:

Previous
From: Jaime Casanova
Date:
Subject: Re: Determining client_encoding from client locale
Next
From: Magnus Hagander
Date:
Subject: Re: Recent vendor SSL renegotiation patches break PostgreSQL