X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 7979C3A585D for ; Wed, 26 Jan 2005 03:06:29 +0000 (GMT) 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 50307-04 for ; Wed, 26 Jan 2005 03:06:21 +0000 (GMT) Received: from mail.astudios.com (ns1.astudios.com [66.49.77.3]) by svr1.postgresql.org (Postfix) with ESMTP id 33D723A5855 for ; Wed, 26 Jan 2005 03:06:24 +0000 (GMT) thread-index: AcUDVCnE8lBW4TZwSL27PviEEJtqxw== Content-Transfer-Encoding: 7bit X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.181 Content-Class: urn:content-classes:message Received: from [192.168.1.103] ([24.211.121.176]) by mail.astudios.com with Microsoft SMTPSVC(6.0.3790.211); Tue, 25 Jan 2005 22:07:22 -0500 Importance: normal Message-ID: <41F70949.9080001@sermonaudio.com> Date: Tue, 25 Jan 2005 22:06:49 -0500 From: "Chris Hoover" User-Agent: Mozilla Thunderbird 1.0 (X11/20041227) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Subject: [Fwd: how to determine storage size of a numeric column] X-Enigmail-Version: 0.89.5.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: multipart/mixed; boundary="------------090902040803090909020004" X-OriginalArrivalTime: 26 Jan 2005 03:07:22.0796 (UTC) FILETIME=[27B0C6C0:01C50354] 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: 200501/266 X-Sequence-Number: 16125 This is a multi-part message in MIME format. --------------090902040803090909020004 Content-Type: text/plain; format=flowed; charset="ISO-8859-1" Content-Transfer-Encoding: 7bit I did not see it come through. resent. --------------090902040803090909020004 Content-Type: message/rfc822; name="how to determine storage size of a numeric column" Content-Transfer-Encoding: 7bit Content-Disposition: inline; filename="how to determine storage size of a numeric column" Message-ID: <41F6B9D1.7060602@sermonaudio.com> Disposition-Notification-To: Chris Hoover Date: Tue, 25 Jan 2005 16:27:45 -0500 From: Chris Hoover User-Agent: Mozilla Thunderbird 1.0 (X11/20041227) X-Accept-Language: en-us, en MIME-Version: 1.0 To: psql-admin@postgresql.org Subject: how to determine storage size of a numeric column X-Enigmail-Version: 0.89.5.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit I'm running 7.3.4, and am trying to calculate the space requirements for my tables. However, I have several tables that have numeric columns, and am not sure how much space postgres is using for them. Does anyone know how to determine this? I have tried looking at pg_attribute.attlen, but it is -l, I have tried looking at pg_attribute.atttypmod, but it is returning what would be huge space requirements (some of them are 786,4400, 786442, 1,179,645, . . .). Is that number really how many bytes it is taking up? I am thinking (and hoping) not. So, where else can I look for the size? thanks, Chris --------------090902040803090909020004--