Обсуждение: relID and tupleID

Поиск
Список
Период
Сортировка

relID and tupleID

От
"S -"
Дата:
Iam trying to figure out what value relID holds in postgresql. relID is 
present is struct LOCKTAG in LOCK.h.
And also, in src/backend/storage/lmgr/readme mentions  'tupleID", I can't 
find what tupleID represents and where its present in posgresql code
Thanks
-sumaira




_________________________________________________________________
Help STOP SPAM with the new MSN 8 and get 2 months FREE*  
http://join.msn.com/?page=features/junkmail



Re: relID and tupleID

От
Tom Lane
Дата:
"S -" <nat_lazy@hotmail.com> writes:
> Iam trying to figure out what value relID holds in postgresql. relID is 
> present is struct LOCKTAG in LOCK.h.

pg_class OID of a table.

> And also, in src/backend/storage/lmgr/readme mentions  'tupleID", I can't 
> find what tupleID represents and where its present in posgresql code

Looks like someone separated tupleid into page number (objId.blkno) and
item number (offnum) to avoid having alignment padding inside the LOCKTAG
struct.
        regards, tom lane



Re: relID and tupleID

От
"S -"
Дата:
in src/backend/storage/lmgr/readme
in the explanation of tag.objId
when it says blockId does it mean
tag.objId.blkno
in LOCKTAG struct in Lock.h ??


so actually the tuple id is comprised of:
Block Number objId.blkno AND OffsetNumber offnum ?

Thank you so much,
Sumaira





>From: Tom Lane <tgl@sss.pgh.pa.us>
>To: "S -" <nat_lazy@hotmail.com>
>CC: pgsql-hackers@postgresql.org
>Subject: Re: [HACKERS] relID and tupleID Date: Sat, 19 Apr 2003 01:49:10 
>-0400
>
>"S -" <nat_lazy@hotmail.com> writes:
> > Iam trying to figure out what value relID holds in postgresql. relID is
> > present is struct LOCKTAG in LOCK.h.
>
>pg_class OID of a table.
>
> > And also, in src/backend/storage/lmgr/readme mentions  'tupleID", I 
>can't
> > find what tupleID represents and where its present in posgresql code
>
>Looks like someone separated tupleid into page number (objId.blkno) and
>item number (offnum) to avoid having alignment padding inside the LOCKTAG
>struct.
>
>            regards, tom lane


_________________________________________________________________
Help STOP SPAM with the new MSN 8 and get 2 months FREE*  
http://join.msn.com/?page=features/junkmail