Re: [WIP] shared row locks

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: [WIP] shared row locks
Дата
Msg-id 20050329043622.GA16785@dcc.uchile.cl
обсуждение исходный текст
Ответ на Re: [WIP] shared row locks  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-patches
On Mon, Mar 28, 2005 at 11:18:05PM -0500, Tom Lane wrote:
> Alvaro Herrera <alvherre@dcc.uchile.cl> writes:
> > 1. To examine a tuple one must first call LockTuple, which grabs a pin
> > and lock in the buffer.  The buffer lock is released right away, but the
> > pin is kept.
>
> Surely you don't mean that *every* access to a tuple now has to go
> through the lock manager :-(.

Hmm.  Only updates (delete/select for update) of the tuples, not a
vanilla select.  Is that what you mean?  I realize I left out the fact
that the old rule still applies when dealing with standard select.

Oh, that's a big hole in the reasoning.  The buffer has to be locked
still in 3 because of this.  Will fix.

>  Have you done any performance testing?

Not really.  Will do tomorrow.

--
Alvaro Herrera (<alvherre[@]dcc.uchile.cl>)
"La principal característica humana es la tontería"
(Augusto Monterroso)

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [WIP] shared row locks
Следующее
От: Christopher Kings-Lynne
Дата:
Сообщение: Re: [WIP] shared row locks