Re: [HACKERS] tablelevel and rowlevel locks - Mailing list pgsql-general

From Alvaro Herrera Munoz
Subject Re: [HACKERS] tablelevel and rowlevel locks
Date
Msg-id 20030904161016.GA15428@dcc.uchile.cl
Whole thread Raw
In response to tablelevel and rowlevel locks  ("Jenny -" <nat_lazy@hotmail.com>)
List 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 by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: NFS performance tuning
Next
From: Csaba Nagy
Date:
Subject: Re: Replaceing records