Re: SSI predicate locking on heap -- tuple or row?

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: SSI predicate locking on heap -- tuple or row?
Дата
Msg-id 4DDA85FF020000250003DB58@gw.wicourts.gov
обсуждение исходный текст
Ответ на Re: SSI predicate locking on heap -- tuple or row?  (Dan Ports <drkp@csail.mit.edu>)
Список pgsql-hackers
Dan Ports <drkp@csail.mit.edu> wrote:
> Specifically, the problem is a missing check in
> OnConflict_CheckForSerializationFailure. We check whether the
> conflict has caused the writer to become a pivot, but only if
> neither the reader or writer is committed. Why is that last
> condition there? In this case, the reader (T4) has committed but
> the writer (T1) hasn't.
OK, I misread your post -- you are looking at T1 as the pivot, and
that test *is* the problem.  When T1 becomes the pivot the reader
(T4) is committed, but it committed *after* T2.  I can submit a
patch for that this evening, after testing to confirm that if finds
the T1 pivot, unless you want to get it.
Sorry for the misunderstanding.  I'm sneaking peeks at this during
compiles of other stuff....
-Kevin


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

Предыдущее
От: Noah Misch
Дата:
Сообщение: Re: Identifying no-op length coercions
Следующее
От: Dan Ports
Дата:
Сообщение: Re: SSI predicate locking on heap -- tuple or row?