Re: SSI heap_insert and page-level predicate locks - Mailing list pgsql-hackers

From Tom Lane
Subject Re: SSI heap_insert and page-level predicate locks
Date
Msg-id 7826.1316199071@sss.pgh.pa.us
Whole thread Raw
In response to Re: SSI heap_insert and page-level predicate locks  (Jeff Davis <pgsql@j-davis.com>)
List pgsql-hackers
Jeff Davis <pgsql@j-davis.com> writes:
> On Wed, 2011-06-08 at 17:29 -0500, Kevin Grittner wrote:
>> Heikki Linnakangas <heikki.linnakangas@enterprisedb.com> wrote:
>>> AFAICS, the check for page lock is actually unnecessary.

>> Absolutely correct.  Patch attached.

> I like the change, but the comment is slightly confusing.

I've committed this patch with comment rewording along the lines
suggested by Jeff.  I also moved the CheckForSerializableConflictIn call
to just before, instead of just after, the RelationGetBufferForTuple
call.  We no longer have to do it after, since we don't need to know
which buffer to pass, and it should buy some more low-level parallelism
to run the SSI checks while not holding exclusive lock on the eventual
target buffer.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Alex Hunsaker
Date:
Subject: Re: /proc/self/oom_adj is deprecated in newer Linux kernels
Next
From: Joshua Berkus
Date:
Subject: Re: unite recovery.conf and postgresql.conf