Re: Possibility of Index-Only access in PostgreSQL?

Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема Re: Possibility of Index-Only access in PostgreSQL?
Дата
Msg-id 007c01c21d8d$e94e9230$0200a8c0@SOL
обсуждение исходный текст
Ответ на Possibility of Index-Only access in PostgreSQL?  (Gunther Schadow <gunther@aurora.regenstrief.org>)
Список pgsql-sql
> - Oracle is content with data read from an index if that is all that's
>    needed. Indeed, I only need bar and baz and those are in the index.
>    The benefits of not having to seek the scattered rows from the data
>    table saves 35000 back and forth head movements / seeks.

Postgres can't use the data from its indices, because of the MVCC mechanism.
Maybe you should try CLUSTERing your table to improve performance???

Chris






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

Предыдущее
От: Jie Liang
Дата:
Сообщение: pg_restore cannot restore function
Следующее
От: q u a d r a
Дата:
Сообщение: graphical interface - admin