Re: Alternative variable length structure

Andrew Dunstan <andrew@dunslane.net>

From: Andrew Dunstan <andrew@dunslane.net>
To: ITAGAKI Takahiro <itagaki.takahiro@lab.ntt.co.jp>
Cc: pgsql-hackers@postgresql.org
Date: 2005-09-08T18:22:28Z
Lists: pgsql-hackers

ITAGAKI Takahiro wrote:

># select * from pgstattuple('txttbl');
>-[ RECORD 1 ]------+------
>table_len          | 8192
>tuple_count        | 1
>tuple_len          | 57    <-- 28 + (5+3) + (5+3) + (5+3) + (5)
>...
>
># select * from pgstattuple('strtbl');
>-[ RECORD 1 ]------+------
>table_len          | 8192
>tuple_count        | 1
>tuple_len          | 36    <-- 28 + 2 + 2 + 2 + 2
>  
>
>

What's the break even point in datum length between the two styles of 
header?

And what is the processing overhead of using variable header length?

cheers

andrew