X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id B98C152B1C for ; Thu, 21 Jul 2005 07:02:11 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 19776-03 for ; Thu, 21 Jul 2005 10:02:10 +0000 (GMT) Received: from charon.4soft.de (charon.4soft.de [62.159.46.131]) by svr1.postgresql.org (Postfix) with ESMTP id 8974B52AE8 for ; Thu, 21 Jul 2005 07:02:06 -0300 (ADT) Received: from zeus.4soft.de (zeus.4soft.de [172.16.0.1]) by charon.4soft.de (Postfix) with ESMTP id C1672D098 for ; Thu, 21 Jul 2005 12:02:08 +0200 (CEST) Received: from [172.16.1.14] (eos.4soft.de [172.16.1.14]) by zeus.4soft.de (8.12.8/8.12.8) with ESMTP id j6LA25Fh012809 for ; Thu, 21 Jul 2005 12:02:05 +0200 Message-ID: <42DF72AA.3090207@4soft.de> Date: Thu, 21 Jul 2005 12:02:18 +0200 From: Achim Luber User-Agent: Mozilla Thunderbird 1.0.2 (Windows/20050317) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Size of empty varchar and size of index X-Enigmail-Version: 0.92.0.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by AMaViS-perl11-milter (http://amavis.org/) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200507/365 X-Sequence-Number: 13606 Hello, I'm searching for two facts: How much space takes a varchar column if there is no value in it (NULL)? How much space needs a index of an integer column? Hope I post to the right list and hope anybody can help me. Thank you Greetings Achim