Postgres Pro
Downloads
Home   >   mailing lists

LOCK.tag(figuring out granularity of lock) - Mailing list pgsql-docs

From Sumaira Maqsood Ali
Subject LOCK.tag(figuring out granularity of lock)
Date
Msg-id 3F493C1D.3090607@purdue.edu
Whole thread Raw
List pgsql-docs
Tree view 
following is taken from postgresql-7.3.2/src/backend/storage/lmgr/readme:

"If we are setting a table level lock
both the blockId and tupleId (in an item pointer this is called
the position) are set to invalid, if it is a page level lock the
blockId is valid, while the tupleId is still invalid.  Finally if
this is a tuple level lock (we currently never do this) then both
the blockId and tupleId are set to valid specifications.  "


is blockId same as tag.objId.blkno?  what field in LOCK.tag is tupleId?
thanks
Sumaira

pgsql-docs by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: [HACKERS] Can't find thread on Linux memory overcommit
Next
From: Tom Lane
Date:
Subject: Do we need "Diagnostics" sections of SQL command reference pages?