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