Re: Maximum len of data fit into the tuple - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Maximum len of data fit into the tuple
Date
Msg-id 11874.961989983@sss.pgh.pa.us
Whole thread Raw
In response to Maximum len of data fit into the tuple  (Denis Perchine <dyp@perchine.com>)
List pgsql-hackers
Denis Perchine <dyp@perchine.com> writes:
> If I will assume that oid == int4 I will have 4 * 2 + 4 (size of
> vl_len in bytea) = 12.  Plus 36 bytes of header (as noted in FAQ). It
> will be 48 bytes... But I still get error that tuple is out too
> big... And that my size is 8188, but should be 8140.

> It would be great if someone will clarify the way I should do such
> calculations.

You forgot the per-page overhead.

Offhand 36 seems too small for the per-tuple overhead, anyway, but I'm
too lazy to count bytes in include/access/htup.h right now...
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [PATCHES] RE: CLASSOID patch
Next
From: Chris Bitmead
Date:
Subject: Re: CLASSOID patch