Re: Alternative variable length structure - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: Alternative variable length structure
Date
Msg-id 43208164.5090303@dunslane.net
Whole thread Raw
In response to Alternative variable length structure  (ITAGAKI Takahiro <itagaki.takahiro@lab.ntt.co.jp>)
List 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


pgsql-hackers by date:

Previous
From: Thomas Hallgren
Date:
Subject: Re: Attention PL authors: want to be listed in template table?
Next
From: Peter Eisentraut
Date:
Subject: Re: initdb profiles