On Wed, Apr 27, 2011 at 5:24 PM, Phoenix Kiula <phoenix(dot)kiula(at)gmail(dot)com> wrote:
> Possibly a dumb question but there isn't much about this.
> 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.
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
In response to
pgsql-general by date
|Next:||From: Alban Hertroys||Date: 2011-04-28 15:29:33|
|Subject: Re: GIN index not used|
|Previous:||From: David Boreham||Date: 2011-04-28 14:48:32|
|Subject: Re: SSDs with Postgresql?|