Fwd: A thought on Index Organized Tables

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



So basically you want to have index-only scans, but you want them to
be really slow?

No Robert, i just asked him to make it optional, so that the crash safe visibility map is used only when its need is realized by the DB designer. When there is a table with no indexes/ a table where the data will be often updated/ a database where there will be a batch job together with OLTP stuff, the visibility map is just useless. So i am requesting Heikki to make it optional. I am not asking him to drop that idea, as it might be useful in read only environments.

Hope, i have not offended you in conveying that.

Thanks,
Gokul.


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

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: pg_stop_backup does not complete
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: pg_stop_backup does not complete