Re: Heap WARM Tuples - Design Draft

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: Heap WARM Tuples - Design Draft
Дата
Msg-id 20160805175655.GE5068@momjian.us
обсуждение исходный текст
Ответ на Re: Heap WARM Tuples - Design Draft  (Claudio Freire <klaussfreire@gmail.com>)
Ответы Re: Heap WARM Tuples - Design Draft  (Pavan Deolasee <pavan.deolasee@gmail.com>)
Список pgsql-hackers
On Fri, Aug  5, 2016 at 02:43:37PM -0300, Claudio Freire wrote:
> But doing the WARM chain backtracking and checking for previous
> versions with appropriate keys should be enough to support this use
> case too, it just needs to be well optimized to avoid seriously
> impacting performance on the average case.

Yes, that was an idea I had to --- if the in-page HOT chain already has
the key, we know it is already in the index and we can skip the index
addition.

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com

+ As you are, so once was I. As I am, so you will be. +
+                     Ancient Roman grave inscription +



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

Предыдущее
От: Claudio Freire
Дата:
Сообщение: Re: Heap WARM Tuples - Design Draft
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Refactoring of heapam code.