granularity of locking

Started by Jenny -over 22 years ago1 messages
#1Jenny -
nat_lazy@hotmail.com

In the LockTag if tupleId is represented by blkno and offnum then is blockId
mentioned below the same as blkno?

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. "

if tupleId is represented by blkno and offnum then is blockId mentioned
below the same as blkno?

_________________________________________________________________
Get MSN 8 and enjoy automatic e-mail virus protection.
http://join.msn.com/?page=features/virus