Re: A thought on Index Organized Tables

Поиск
Список
Период
Сортировка
От Greg Stark
Тема Re: A thought on Index Organized Tables
Дата
Msg-id 407d949e1002240923t552a9ab8pafd17000856726c9@mail.gmail.com
обсуждение исходный текст
Ответ на Re: A thought on Index Organized Tables  (Gokulakannan Somasundaram <gokul007@gmail.com>)
Ответы Re: A thought on Index Organized Tables
Список pgsql-hackers
On Wed, Feb 24, 2010 at 4:12 PM, Gokulakannan Somasundaram
<gokul007@gmail.com> wrote:
> Sequential scans can be done on IOTs, just scan through the leaf pages.

That doesn't work because when you split an index page any sequential
scan in progress will either see the same tuples twice or will miss
some tuples depending on where the new page is allocated. Vacuum has a
clever trick for solving this but it doesn't work for arbitrarily many
concurrent scans.



-- 
greg


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