Search Postgresql Archives

NULL saves disk space?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: PG-General Mailing List <pgsql-general@xxxxxxxxxxxxxx>
Subject: NULL saves disk space?
From: Phoenix Kiula <phoenix.kiula@xxxxxxxxx>
Date: Thu, 28 Apr 2011 00:24:13 +0800

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

Follow-Ups:
- Re: NULL saves disk space?
  - From: Massa, Harald Armin
- Re: NULL saves disk space?
  - From: Simon Riggs
- Re: NULL saves disk space?
  - From: David Johnston

Prev by Date: Re: Column storage (EXTERNAL/EXTENDED) settings for bytea/text column
Next by Date: Re: PHP and PostgreSQL 9.0, pg_connect fails to connect
Previous by thread: Index not being used for UPDATE?
Next by thread: Re: NULL saves disk space?
Index(es):
- Date
- Thread

[Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Programming PHP] [Kernel Newbies] [PHP Classes] [Find Someone Nice] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]