A thought on Index Organized Tables
От | Gokulakannan Somasundaram |
---|---|
Тема | A thought on Index Organized Tables |
Дата | |
Msg-id | 9362e74e1002211111n533646c8q8b5c074568267f04@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: A thought on Index Organized Tables
|
Список | 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 по дате отправления: