Re: A thought on Index Organized Tables

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: A thought on Index Organized Tables
Дата
Msg-id 9818.1267143664@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: A thought on Index Organized Tables  (Karl Schnaitter <karlsch@gmail.com>)
Ответы Re: A thought on Index Organized Tables  (Gokulakannan Somasundaram <gokul007@gmail.com>)
Список pgsql-hackers
Karl Schnaitter <karlsch@gmail.com> writes:
> Of course, PG can't "support" indexing with incorrect functions. However,
> it's worthwhile to guard against too much damage being done if the user's
> function has a bug. Maybe I'm wrong? Maybe an index tuple with a dangling
> pointer is actually harmless?

No, it's far from harmless.  As soon as that heap TID gets filled with
an unrelated tuple, you run the risk of indexscans alighting on and
perhaps modifying the wrong tuple.
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: psql with "Function Type" in \df
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: A thought: should we run pgindent now?