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

From Gokulakannan Somasundaram
Subject A thought on Index Organized Tables
Date
Msg-id 9362e74e1002211111n533646c8q8b5c074568267f04@mail.gmail.com
Whole thread Raw
Responses Re: A thought on Index Organized Tables
List pgsql-hackers
Hi,<br />    As you all know, Index Organized tables are a way by which we can automatically cluster the data based on
theprimary key. While i was thinking about an implementation for postgres, it looks like an impossible with the current
ideologies.In an IOT, if a record gets updated, we need to mark the old row as deleted immediately, as we do with any
othertable. But since Postgres supports user defined data types and if they happen to be a broken data type, then we
havean unstable IOT.(as there is no guarantee, we might hit the same record)<br />     This was the reason for which,
theproposal on creating  indexes with snapshot was rejected. <br />    May i get a little clarification on this issue?
Willwe be supporting the IOT feature in postgres in future?<br /><br /> Thanks,<br />Gokul.<br /><br /> 

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: PGXS: REGRESS_OPTS=--load-language=plpgsql
Next
From: Bruce Momjian
Date:
Subject: Re: PGXS: REGRESS_OPTS=--load-language=plpgsql