Re: A thought on Index Organized Tables

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

It does.  The point is that the system is set up to limit the bad
consequences.  You might (will) get wrong query answers, but the
heap data won't get corrupted.


Again Tom, if there is an update based on index scan, then it takes the tupleid and updates the wrong heap data right?
The only difference between normal index and thick index is to reach back to the same index tuple to update the snapshot. How will that corrupt the heap data? Did you intend to say that it corrupts the index data?

Thanks,
Gokul.

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

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