Re: UNDO and in-place update

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: UNDO and in-place update
Дата
Msg-id 20161128145034.GA31951@momjian.us
обсуждение исходный текст
Ответ на Re: UNDO and in-place update  (Amit Kapila <amit.kapila16@gmail.com>)
Список pgsql-hackers
On Sun, Nov 27, 2016 at 09:19:06AM +0530, Amit Kapila wrote:
> At this point, index scan for value 2 will find index tuple of step-1
> (2) and will conclude 2,def as a right tuple, but actually, that is
> wrong as the step-1 (2) index tuple should not be visible to the user.
> Do you also this as a problem or am I missing something?  If this a
> problem, then I think we need some form of delete marking system for
> the index, probably transaction visibility information as well.

Yes, very similar to the problems with WARM already discussed.

--  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 по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Mail thread references in commits
Следующее
От: Robert Haas
Дата:
Сообщение: Re: Proposal: scan key push down to heap [WIP]