Thread: Size of row-metadata?
What is the width (in bytes) of the meta data associated with each row in postgresql?
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
> 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.
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