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