Re: Maintaining cluster order on insert

Поиск
Список
Период
Сортировка
От Gregory Stark
Тема Re: Maintaining cluster order on insert
Дата
Msg-id 87wsy1hckn.fsf@oxford.xeocode.com
обсуждение исходный текст
Ответ на Re: Maintaining cluster order on insert  (Heikki Linnakangas <heikki@enterprisedb.com>)
Список pgsql-patches
"Heikki Linnakangas" <heikki@enterprisedb.com> writes:

> The reason for switching to the new API instead of the amsuggestblock API is
> CPU overhead. It avoids constructing the IndexTuple twice and descending the
> tree twice.

I wonder if it's possible to finesse this. Have the suggestblock function
remember the last block it suggested and somehow recognize when it's given the
same tuple to index. Keeping the block pinned would still be the sticky point
though.


--
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com


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

Предыдущее
От: Heikki Linnakangas
Дата:
Сообщение: Re: Maintaining cluster order on insert
Следующее
От: "Simon Riggs"
Дата:
Сообщение: Remove comment about tab-complete.c