Re: [HACKERS] Proposal for Null Bitmap Optimization(for TrailingNULLs)

Поиск
Список
Период
Сортировка
От Gokulakannan Somasundaram
Тема Re: [HACKERS] Proposal for Null Bitmap Optimization(for TrailingNULLs)
Дата
Msg-id 9362e74e0712200036l29081b1eq3ad0e815f07a3ee8@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [HACKERS] Proposal for Null Bitmap Optimization(for TrailingNULLs)  ("Joshua D. Drake" <jd@commandprompt.com>)
Ответы Re: [HACKERS] Proposal for Null Bitmap Optimization(for TrailingNULLs)  (Decibel! <decibel@decibel.org>)
Список pgsql-patches
Thanks for the suggestions. I am re-submitting the patch in contextual diff format.

As far as storage savings are concened, the patch claims whatever is stated. I checked it by creating a table with 10 columns on a 32 bit machine. i inserted 100,000 rows with trailing nulls and i observed savings of 400Kbytes.
I did a similar test for index and i found similar space saving.

I have tested regression in both 32 bit system and 64 bit system.

Please go through the patch and provide further suggestions.

--
Thanks,
Gokul.
CertoSQL Project,
Allied Solution Group.
( www.alliedgroups.com)
Вложения

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

Предыдущее
От: "Hiroshi Saito"
Дата:
Сообщение: Re: win32.mak patch
Следующее
От: Jan Urbański
Дата:
Сообщение: typo in func.sgml