Re: [HACKERS] reduce null bitmap size

2011-11-11 Thread YAMAMOTO Takashi
hi, > y...@mwd.biglobe.ne.jp (YAMAMOTO Takashi) writes: >> how about making heap_form_tuple and its variants use smaller natts for >> tuples whose trailing columns are NULL? > > This idea has been proposed before, and rejected on the basis that it's > unlikely to save enough to be worth the cycle

Re: [HACKERS] reduce null bitmap size

2011-11-09 Thread Tom Lane
y...@mwd.biglobe.ne.jp (YAMAMOTO Takashi) writes: > how about making heap_form_tuple and its variants use smaller natts for > tuples whose trailing columns are NULL? This idea has been proposed before, and rejected on the basis that it's unlikely to save enough to be worth the cycles needed to che

[HACKERS] reduce null bitmap size

2011-11-09 Thread YAMAMOTO Takashi
hi, how about making heap_form_tuple and its variants use smaller natts for tuples whose trailing columns are NULL? depending on the schema, it can save considerable space. the most of code are ready to deal with such tuples for ALTER TABLE ADD COLUMN anyway. (except system catalogs?) YAMAMOTO