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