Re: SSI bug? - Mailing list pgsql-hackers

From Kevin Grittner
Subject Re: SSI bug?
Date
Msg-id 4D639519020000250003AE0D@gw.wicourts.gov
Whole thread Raw
In response to Re: SSI bug?  (Dan Ports <drkp@csail.mit.edu>)
Responses Re: SSI bug?  (Dan Ports <drkp@csail.mit.edu>)
List 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 by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: pg_resetxlog display bogosity
Next
From: Heikki Linnakangas
Date:
Subject: Re: pg_basebackup and wal streaming