Re: Efficient use of space in large table? - Mailing list pgsql-general

From Curt Sampson
Subject Re: Efficient use of space in large table?
Date
Msg-id Pine.NEB.4.44.0207081254150.476-100000@angelic.cynic.net
Whole thread Raw
In response to Re: Efficient use of space in large table?  (Manfred Koizar <mkoi-pg@aon.at>)
Responses Re: Efficient use of space in large table?
List pgsql-general
On Fri, 5 Jul 2002, Manfred Koizar wrote:

> first of all, text is ok.  You might want to store NULL instead of ''
> to squeeze out a few bytes here and there.

Correct me if I'm wrong, but doesn't NULL take up *more* room than ''?
After all, as soon as you have a NULL, you have to have a null bit array
in the tuple.

cjs
--
Curt Sampson  <cjs@cynic.net>   +81 90 7737 2974   http://www.netbsd.org
    Don't you know, in this new Dark Age, we're all light.  --XTC




pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: database backup
Next
From: Bruce Momjian
Date:
Subject: Error messages changes for 7.3?