Re: reduce null bitmap size

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: reduce null bitmap size
Дата
Msg-id 15115.1320856755@sss.pgh.pa.us
обсуждение исходный текст
Ответ на reduce null bitmap size  (yamt@mwd.biglobe.ne.jp (YAMAMOTO Takashi))
Ответы Re: reduce null bitmap size  (yamt@mwd.biglobe.ne.jp (YAMAMOTO Takashi))
Список pgsql-hackers
yamt@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 check for the
case.  Keep in mind that you aren't going to save anything at all unless
the bitmap length decreases across a MAXALIGN boundary.
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Robert Treat
Дата:
Сообщение: Re: Measuring relation free space
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: parallel make failure