Re: Proposal for Null Bitmap Optimization(for TrailingNULLs) - Mailing list pgsql-hackers

From Gokulakannan Somasundaram
Subject Re: Proposal for Null Bitmap Optimization(for TrailingNULLs)
Date
Msg-id 9362e74e0712171035q4c5638eajbb3be6b9bd3ec9bb@mail.gmail.com
Whole thread Raw
In response to Re: Proposal for Null Bitmap Optimization(for TrailingNULLs)  (Gregory Stark <stark@enterprisedb.com>)
Responses Re: Proposal for Null Bitmap Optimization(for TrailingNULLs)  ("Gokulakannan Somasundaram" <gokul007@gmail.com>)
List pgsql-hackers
Hi,<br />   I made the fix and tested it today. It involved some 10-15 lines of code change. I will mail it tomorrow.
Feelfree to give suggestions on making the fix more maintainable.<br />   I have followed Gregory's advice in the fix
- Instead of changing the slot_deform_tuple, i have reduced the number of attributes field of the
HeapTupleHeader(duringinsertion), so that the trailing nulls are treated the same as newly added columns. Thanks
Gregory.<br />   Regarding arrangement of the columns, my take is to leave it to the user on the arrangement of the
columns.May be we can put some kind of tuning hint somewhere in our document on the suggestions. I have made the above
statement,without thinking about other advantages, if any.  <br /><br clear="all" /><br />-- <br />Thanks,<br
/>Gokul.<br/>CertoSQL Project,<br />Allied Solution Group.<br />(<a
href="http://www.alliedgroups.com">www.alliedgroups.com</a>) 

pgsql-hackers by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Board for developers
Next
From: Heikki Linnakangas
Date:
Subject: Re: Board for developers