Skip site navigation (1) Skip section navigation (2)

NULL saves disk space?

From: Phoenix Kiula <phoenix(dot)kiula(at)gmail(dot)com>
To: PG-General Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: NULL saves disk space?
Date: 2011-04-27 16:24:13
Message-ID: BANLkTinMjecW9yGBcYoyF3C+pDmSdz+cLg@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-general
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...

Responses

pgsql-general by date

Next:From: Michael NolanDate: 2011-04-27 16:24:26
Subject: Re: PHP and PostgreSQL 9.0, pg_connect fails to connect
Previous:From: Phoenix KiulaDate: 2011-04-27 16:15:57
Subject: Index not being used for UPDATE?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group