Re: Maximum len of data fit into the tuple

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Maximum len of data fit into the tuple
Дата
Msg-id 11874.961989983@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Maximum len of data fit into the tuple  (Denis Perchine <dyp@perchine.com>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [PATCHES] RE: CLASSOID patch
Следующее
От: Chris Bitmead
Дата:
Сообщение: Re: CLASSOID patch