Re: A thought on Index Organized Tables

Поиск
Список
Период
Сортировка
От Gokulakannan Somasundaram
Тема Re: A thought on Index Organized Tables
Дата
Msg-id 9362e74e1002252033t1fe97293y2a9a655233edb282@mail.gmail.com
обсуждение исходный текст
Ответ на Re: A thought on Index Organized Tables  (Gokulakannan Somasundaram <gokul007@gmail.com>)
Список pgsql-hackers


On Fri, Feb 26, 2010 at 9:54 AM, Gokulakannan Somasundaram <gokul007@gmail.com> wrote:

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.


Tom,
     i think this will never happen. The only issue is when we need to go back to the index from heap. This is to update the timestamps of update/delete.

Gokul.

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

Предыдущее
От: Alex Hunsaker
Дата:
Сообщение: Re: Avoiding bad prepared-statement plans.
Следующее
От: Alex Hunsaker
Дата:
Сообщение: Re: Avoiding bad prepared-statement plans.