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

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Reply via email to