Postgres Pro
Downloads
Home   >   mailing lists

Storage space usage - Mailing list pgsql-performance

From Gangadharan S.A.
Subject Storage space usage
Date
Msg-id e36d60c10802010044o40143aaybcbbfa223d289a35@mail.gmail.com
Whole thread Raw
Responses Re: Storage space usage
List pgsql-performance
Tree view
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 optimized for storage?
Thanks,
Gangadharan

pgsql-performance by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: How do I bulk insert to a table without affecting read performance on that table?
Next
From: Decibel!
Date:
Subject: Re: Storage space usage