Re: A thought on Index Organized Tables

Поиск
Список
Период
Сортировка
От Gokulakannan Somasundaram
Тема Re: A thought on Index Organized Tables
Дата
Msg-id 9362e74e1002241113k185eadfasc5ae9e7164fe243e@mail.gmail.com
обсуждение исходный текст
Ответ на Re: A thought on Index Organized Tables  (Greg Stark <gsstark@mit.edu>)
Список pgsql-hackers
It might be slightly easier given the assumption that you only want to
scan leaf tuples.

But there's an additional problem I didn't think of before. Currently
we optimize index scans by copying all relevant tuples to local memory
so we don't need to hold an index lock for an extended time or spend a
lot of time relocking and rechecking the index for changes. That
wouldn't be possible if we needed to get visibility info from the page
since we would need up-to-date information.


We should solve this issue in the same way, of how we proceed with the index only quals, in current index-only scans.

Gokul.
 

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

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