Home > mailing lists

NULL saves disk space? - Mailing list pgsql-general

From	Phoenix Kiula
Subject	NULL saves disk space?
Date	April 27, 2011 16:24:28
Msg-id	BANLkTinMjecW9yGBcYoyF3C+pDmSdz+cLg@mail.gmail.com Whole thread Raw
Responses	Re: NULL saves disk space? Re: NULL saves disk space? Re: NULL saves disk space?
List	pgsql-general

Tree view

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...

pgsql-general by date:

From: Joel Stevenson
Date: 27 April 2011, 16:18:07
Subject: Re: Column storage (EXTERNAL/EXTENDED) settings for bytea/text column

From: Michael Nolan
Date: 27 April 2011, 16:24:47
Subject: Re: PHP and PostgreSQL 9.0, pg_connect fails to connect

NULL saves disk space? - Mailing list pgsql-general

Previous

Next