granularity of locking

Поиск
Список
Период
Сортировка
От Jenny -
Тема granularity of locking
Дата
Msg-id BAY1-F61vX4pE2iNlg40001bc47@hotmail.com
обсуждение исходный текст
Список pgsql-general
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


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

Предыдущее
От: Andreas Fromm
Дата:
Сообщение: Re: inserting via "on insert" rule
Следующее
От: Ron Johnson
Дата:
Сообщение: Re: About GPL and proprietary software