Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 6F7E12E0216 for ; Fri, 1 Feb 2008 04:44:24 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 59402-07 for ; Fri, 1 Feb 2008 04:44:17 -0400 (AST) Received: from hs-out-2122.google.com (hs-out-0708.google.com [64.233.178.240]) by postgresql.org (Postfix) with ESMTP id 2F8192E019D for ; Fri, 1 Feb 2008 04:44:21 -0400 (AST) Received: by hs-out-2122.google.com with SMTP id k27so1023660hsc.3 for ; Fri, 01 Feb 2008 00:44:20 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type; bh=cmSTQqW+iQIcr58w11ySOucOnuSKUmLqlk6PvJjX0y8=; b=uWqbzJG9Mnj/vcgBLl1iDHXIMqrhgavmVTFYhGsSVNc1phTocmnYSrqF/3eAu+KJk56Tt96jtZBRfTBLfamBXeIczpcdWo/fsbKgjM8xBCPFMW91kXS9FM7fIBFFxHr7OMBosXJQqIpsobv/BtpT1A0nK/zrRMpUyzX91V0Y/lY= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:mime-version:content-type; b=RNEz9NqJajPEFjnIcss9TWEcEc7pc/VTV53w6X8k7KZJ9Wku6VB+kkFlJuzs8jT+fbfBdVWM/Q/6G8c/jQ3ZymWfkOZKKjoJA6PNWiuwXmb8ThcymuEI+I2ZpVBPXPUYSWvm79eHfPEhTgHpMCbUckSk237qjszG7W9nnIW3hY8= Received: by 10.142.194.1 with SMTP id r1mr1923192wff.176.1201855458899; Fri, 01 Feb 2008 00:44:18 -0800 (PST) Received: by 10.143.122.4 with HTTP; Fri, 1 Feb 2008 00:44:18 -0800 (PST) Message-ID: Date: Fri, 1 Feb 2008 14:14:18 +0530 From: "Gangadharan S.A." To: pgsql-performance@postgresql.org Subject: Storage space usage MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_22339_28949953.1201855458843" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200802/1 X-Sequence-Number: 28543 ------=_Part_22339_28949953.1201855458843 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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 ------=_Part_22339_28949953.1201855458843 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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 ------=_Part_22339_28949953.1201855458843--