Re: Re: patch submission: truncate trailing nulls from heap rows to reduce the size of the null bitmap - Mailing list pgsql-hackers

From Gokulakannan Somasundaram
Subject Re: Re: patch submission: truncate trailing nulls from heap rows to reduce the size of the null bitmap
Date
Msg-id CAHMh4-aGz-_dENoG-OvA-228AzfoeH1dRWr6b2LgejcsGdQmBA@mail.gmail.com
Whole thread Raw
In response to Re: Re: patch submission: truncate trailing nulls from heap rows to reduce the size of the null bitmap  (Simon Riggs <simon@2ndQuadrant.com>)
List 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 by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Re: patch submission: truncate trailing nulls from heap rows to reduce the size of the null bitmap
Next
From: "Erik Rijkers"
Date:
Subject: Re: Patch: add conversion from pg_wchar to multibyte