Re: relID and tupleID

From: "S -" <nat_lazy(at)hotmail(dot)com>
To: tgl(at)sss(dot)pgh(dot)pa(dot)us, pgsql-hackers(at)postgresql(dot)org
Subject: Re: relID and tupleID
Date: 2003-04-19 06:07:02
Message-ID: BAY1-F883vSAMfKQu1b00000410@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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(at)sss(dot)pgh(dot)pa(dot)us>
>To: "S -" <nat_lazy(at)hotmail(dot)com>
>CC: pgsql-hackers(at)postgresql(dot)org
>Subject: Re: [HACKERS] relID and tupleID Date: Sat, 19 Apr 2003 01:49:10
>-0400
>
>"S -" <nat_lazy(at)hotmail(dot)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

Browse pgsql-hackers by date

  From Date Subject
Next Message Christopher Kings-Lynne 2003-04-19 09:21:46 Re: For the ametures. (related to "Are we losing momentum?")
Previous Message Tom Lane 2003-04-19 05:49:10 Re: relID and tupleID