Re: SSI heap_insert and page-level predicate locks

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: SSI heap_insert and page-level predicate locks
Дата
Msg-id 7826.1316199071@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: SSI heap_insert and page-level predicate locks  (Jeff Davis <pgsql@j-davis.com>)
Список 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 по дате отправления:

Предыдущее
От: Alex Hunsaker
Дата:
Сообщение: Re: /proc/self/oom_adj is deprecated in newer Linux kernels
Следующее
От: Joshua Berkus
Дата:
Сообщение: Re: unite recovery.conf and postgresql.conf