Re: [PERFORM] Storage space usage

2008-02-01 Thread Decibel!
On Fri, Feb 01, 2008 at 02:14:18PM +0530, Gangadharan S.A. wrote: > Hi, > I have 2 questions regarding the storage optimization done by Postgres: > 1) Is a NULL value optimized for storage. If I have a timestamp (or some > such) field that I set to default NULL, will it still use up the full space

[PERFORM] Storage space usage

2008-02-01 Thread Gangadharan S.A.
Hi, I have 2 questions regarding the storage optimization done by Postgres: 1) Is a NULL value optimized for storage. If I have a timestamp (or some such) field that I set to default NULL, will it still use up the full space for the data type. 2) Similarly, if I have a text array, is an empty array