Re: A thought on Index Organized Tables
| От | Gokulakannan Somasundaram |
|---|---|
| Тема | Re: A thought on Index Organized Tables |
| Дата | |
| Msg-id | 9362e74e1002241034x7bbfcd4eh45f6beb521a99af4@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: A thought on Index Organized Tables (Tom Lane <tgl@sss.pgh.pa.us>) |
| Список | pgsql-hackers |
On Wed, Feb 24, 2010 at 10:09 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
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."Kevin Grittner" <Kevin.Grittner@wicourts.gov> writes:Isn't that just a variant on Heikki's "grouped index tuples" idea?
> 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.
regards, tom lane
Gokul.
В списке pgsql-hackers по дате отправления: