Re: Proposal for Null Bitmap Optimization(for TrailingNULLs)
| От | Gokulakannan Somasundaram |
|---|---|
| Тема | Re: Proposal for Null Bitmap Optimization(for TrailingNULLs) |
| Дата | |
| Msg-id | 9362e74e0712171035q4c5638eajbb3be6b9bd3ec9bb@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Proposal for Null Bitmap Optimization(for TrailingNULLs) (Gregory Stark <stark@enterprisedb.com>) |
| Ответы |
Re: Proposal for Null Bitmap Optimization(for TrailingNULLs)
|
| Список | 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 по дате отправления: