Re: SSI bug?

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: SSI bug?
Дата
Msg-id 4D639519020000250003AE0D@gw.wicourts.gov
обсуждение исходный текст
Ответ на Re: SSI bug?  (Dan Ports <drkp@csail.mit.edu>)
Ответы Re: SSI bug?  (Dan Ports <drkp@csail.mit.edu>)
Список pgsql-hackers
Dan Ports <drkp@csail.mit.edu> wrote:
> It looks like CheckTargetForConflictsIn is making the assumption
> that the backend-local lock table is accurate, which was probably
> even true at the time it was written.
I remember we decided that it could only be false in certain ways
which allowed us to use it as a "lossy" first-cut test in a couple
places.  I doubt that we can count on any of that any longer, and
should drop those heuristics.
> the new changes for tuple versions make it more likely that this
> will actually come up.
Yeah, as far as a I can recall the only divergence was in *page*
level entries for *indexes* until this latest patch.  We now have
*tuple* level entries for *heap* relations, too.
> The solution is only slightly more complicated than just removing
> the assertion.
That's certainly true for that one spot, but we need an overall
review of where we might be trying to use LocalPredicateLockHash for
"first cut" tests as an optimization.
> Unless Kevin beats me to it, I'll put together a patch later
> tonight or tomorrow. (I'm at the airport right now.)
It would be great if you could get this one.  Thanks.
-Kevin


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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: pg_resetxlog display bogosity
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: Re: pg_basebackup and wal streaming