Re: A thought on Index Organized Tables

Поиск
Список
Период
Сортировка
От Gokulakannan Somasundaram
Тема Re: A thought on Index Organized Tables
Дата
Msg-id 9362e74e1002260457m1f73254dradcf6054b57d7e1e@mail.gmail.com
обсуждение исходный текст
Ответ на Re: A thought on Index Organized Tables  (Karl Schnaitter <karlsch@gmail.com>)
Список pgsql-hackers
It definitely affects current indexes. We can't completely avoid bad user functions. That is why it is important to put limits on how much damage they can do. That's the motivation for the idea I mentioned before, of double-checking visibility data in an IndexTuple before letting it survive a VACUUM.

No i don't say it would affect Vacuum, but i am suspecting that it would affect Index based select. Since Vacuum uses a sequential scan of tuples, it doesn't require the ordering operator, but any index based search would require a ordering operator for binary search and for comparing with the right most key.

Thanks,
Gokul.

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

Предыдущее
От: Greg Stark
Дата:
Сообщение: Re: A thought on Index Organized Tables
Следующее
От: Greg Stark
Дата:
Сообщение: Re: pg_stop_backup does not complete