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  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Список 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 по дате отправления:

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: PGXS: REGRESS_OPTS=--load-language=plpgsql
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: PGXS: REGRESS_OPTS=--load-language=plpgsql