Re: [HACKERS] tablelevel and rowlevel locks

Поиск
Список
Период
Сортировка
От Alvaro Herrera Munoz
Тема Re: [HACKERS] tablelevel and rowlevel locks
Дата
Msg-id 20030904161016.GA15428@dcc.uchile.cl
обсуждение исходный текст
Ответ на tablelevel and rowlevel locks  ("Jenny -" <nat_lazy@hotmail.com>)
Список pgsql-general
On Thu, Sep 04, 2003 at 08:56:31AM -0700, Jenny - wrote:
> I am working on a project that involves displaying locking information
> about each lock taken, whether it be a row level or  table leve llock.
> When dealing with struct LOCK (src/include/storage) i have noticed that
> postgreSQL creates a single LOCK  struct for each table in the  db. Like if
> i acquire 2 seperate row level locks on 2 seperate rows, both these locks
> are represented in the same struct LOCK datastructure.

I think the locks would actually by represented by PROCLOCK structures.
The LOCK structures are for lockable objects, not for actual locks.

--
Alvaro Herrera (<alvherre[@]dcc.uchile.cl>)
"Vivir y dejar de vivir son soluciones imaginarias.
La existencia est� en otra parte" (Andre Breton)

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

Предыдущее
От: "scott.marlowe"
Дата:
Сообщение: Re: NFS performance tuning
Следующее
От: Csaba Nagy
Дата:
Сообщение: Re: Replaceing records