The tid is the page/offset of the tuple. You can't really remove it
because it is a characteristic of the tuple, not really in each tuple.
Each page has a number, and each page has slots, so the page number/slot
number of the tuple is its tid.
However, there is a ctid element in the heap tuple header:
ItemPointerData t_ctid; /* current TID of this or newer tuple */
and that is used more make tid access easier and to chain tuples to
newer versions. Not much saving there.
7.3 will reduce the typle header by 8 bytes, so there is progress being
made on tuple overhead reduction.
---------------------------------------------------------------------------
Tourtounis Sotiris wrote:
> In Postgres documentation there is a reference of the tid that is by
> default inserted for each tuple in the database where is it, which takes
> an extra percent of the database's storage space.
> It's referred that is of the general form:
> tid : <block number, tuple index within each block>
> Is it possible afterwards the installation of Postgres to not have
> it on database's size. Or most important can we see its size (tid) per
> tuple or totally to the whole database (size of the block number , size
> of tuple index within each block)? Does it have some default values and
> which are those?Thanks you
>
>
>
> SWTHRHS TOYRTOYNHS
> (tourtoun@csd.uch.gr)
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073