Re: Re: patch submission: truncate trailing nulls from heap rows to reduce the size of the null bitmap

Поиск
Список
Период
Сортировка
От Gokulakannan Somasundaram
Тема Re: Re: patch submission: truncate trailing nulls from heap rows to reduce the size of the null bitmap
Дата
Msg-id CAHMh4-aGz-_dENoG-OvA-228AzfoeH1dRWr6b2LgejcsGdQmBA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Re: patch submission: truncate trailing nulls from heap rows to reduce the size of the null bitmap  (Simon Riggs <simon@2ndQuadrant.com>)
Список pgsql-hackers
Дерево обсуждения
There might be a patch available for this already. In the worst case articulated above (less than 64 columns), if all the nulls are trailing nulls, the bitmap need not be saved. Actually it is not 64(actually 72), as postgres heaptupleheader is only 23 bytes and one byte is left for the start of the bitmap.

The same principle can be considered for Index Tuple as an extension

Thanks,
Gokul.

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

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: Re: patch submission: truncate trailing nulls from heap rows to reduce the size of the null bitmap
Следующее
От: "Erik Rijkers"
Дата:
Сообщение: Re: Patch: add conversion from pg_wchar to multibyte