Skip site navigation (1) Skip section navigation (2)

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

From: Gokulakannan Somasundaram <gokul007(at)gmail(dot)com>
To: Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc: Robert Haas <robertmhaas(at)gmail(dot)com>, Greg Stark <stark(at)mit(dot)edu>, Josh Berkus <josh(at)agliodbs(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Re: patch submission: truncate trailing nulls from heap rows to reduce the size of the null bitmap
Date: 2012-04-29 11:50:49
Message-ID: CAHMh4-aGz-_dENoG-OvA-228AzfoeH1dRWr6b2LgejcsGdQmBA@mail.gmail.com (view raw or flat)
Thread:
Lists: 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.

In response to

pgsql-hackers by date

Next:From: Erik RijkersDate: 2012-04-29 12:12:49
Subject: Re: Patch: add conversion from pg_wchar to multibyte
Previous:From: Simon RiggsDate: 2012-04-29 11:19:03
Subject: Re: Re: patch submission: truncate trailing nulls from heap rows to reduce the size of the null bitmap

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group