Thread: Size of row-metadata?

Size of row-metadata?

From
tmp
Date:
What is the width (in bytes) of the meta data associated with each row
in postgresql?

Re: Size of row-metadata?

From
"A. Kretschmer"
Date:
In response to tmp :
> What is the width (in bytes) of the meta data associated with each row
> in postgresql?

http://www.postgresql.org/docs/8.4/static/storage-page-layout.html

--
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG: 0x31720C99, 1006 CCB4 A326 1D42 6431  2EB0 389D 1DC2 3172 0C99

Re: Size of row-metadata?

From
tmp
Date:
> http://www.postgresql.org/docs/8.4/static/storage-page-layout.html

I fail to find the size of the *row* header on that link.

Re: Size of row-metadata?

From
Thomas Kellerer
Date:
tmp, 20.01.2010 11:25:
>> http://www.postgresql.org/docs/8.4/static/storage-page-layout.html
>
> I fail to find the size of the *row* header on that link.
>
"All table rows are structured in the same way. There is a fixed-size header (occupying 23 bytes on most machines),
followedby an optional null bitmap, an optional object ID field, and the user data. The header is detailed in Table
53-4."

http://www.postgresql.org/docs/8.4/static/storage-page-layout.html#HEAPTUPLEHEADERDATA-TABLE