Re: NULL saves disk space?
От
Simon Riggs
Тема
Re: NULL saves disk space?
Дата
Msg-id
BANLkTimCGA9qDsAorBOr=FqibRVxhjhkHw@mail.gmail.com
Ответ на
NULL saves disk space? (Phoenix Kiula)
Список
Дерево обсуждения
NULL saves disk space? Phoenix Kiula <phoenix.kiula@gmail.com>
Re: NULL saves disk space? Simon Riggs <simon@2ndQuadrant.com>
Re: NULL saves disk space? Phoenix Kiula <phoenix.kiula@gmail.com>
Re: NULL saves disk space? David Johnston <polobo@yahoo.com>
Re: NULL saves disk space? "Massa, Harald Armin" <harald@2ndquadrant.de>
Re: NULL saves disk space? David Johnston <polobo@yahoo.com>
On Wed, Apr 27, 2011 at 5:24 PM, Phoenix Kiula wrote: > Possibly a dumb question but there isn't much about this. > http://www.google.com/search?sourceid=chrome&ie=UTF-8&q=postgresql+null+value+disk+space > I have some BOOLEAN columns. 90% of the cases of the columns is FALSE. Do I > save disk space by having them as NULL instead of FALSE? So my application > would have conditional code for NULL and TRUE, instead of FALSE and TRUE. > Thanks... Yes, NULL values take no additional space, but the row needs a null bitmap so it is possible that if this was the only NULL then it could occupy more space. If you have multiple columns, then you should use NULLs. -- Simon Riggs http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services
В списке pgsql-general по дате отправления
