Re: Table clustering idea - Mailing list pgsql-hackers

From Kim Bisgaard
Subject Re: Table clustering idea
Date
Msg-id 44A0F05C.4070608@dmi.dk
Whole thread Raw
In response to Re: Table clustering idea  ("Jim C. Nasby" <jnasby@pervasive.com>)
List pgsql-hackers
Jim C. Nasby wrote:
> On Sun, Jun 25, 2006 at 08:04:18PM -0400, Luke Lonergan wrote:
>   
>> Other DBMS have index organized tables that can use either hash or btree
>> organizations, both of which have their uses.  We are planning to
>> implement btree organized tables sometime - anyone else interested in
>> this idea?
>>     
>
> I'm curious how you'll do it, as I was once told that actually trying to
> store heap data in a btree structure would be a non-starter (don't
> remember why).
>   
Ingres is now open source - they have clustering on btree/isam/hash 
(it's called "modify table xx to btree on col1,col2")

Regards,
Kim



pgsql-hackers by date:

Previous
From: Hannu Krosing
Date:
Subject: Re: vacuum, performance, and MVCC
Next
From: "Zeugswetter Andreas DCP SD"
Date:
Subject: Re: [PATCHES] Non-transactional pg_class, try 2