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 1D0A23A3CB4 for ; Mon, 3 Jan 2005 18:58:37 +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 08456-02 for ; Mon, 3 Jan 2005 18:58:10 +0000 (GMT) Received: from mail.astudios.com (ns1.astudios.com [66.49.77.3]) by svr1.postgresql.org (Postfix) with ESMTP id A47603A3CEA for ; Mon, 3 Jan 2005 18:53:22 +0000 (GMT) thread-index: AcTxxZKID6ftMHgZRI6ZSk90HBdhoQ== Content-Class: urn:content-classes:message Importance: normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.181 Received: from webserver ([10.0.0.10]) by mail.astudios.com with Microsoft SMTPSVC(6.0.3790.211); Mon, 3 Jan 2005 13:53:54 -0500 From: "Chris Hoover" To: Date: Mon, 03 Jan 2005 18:53:25 (GMT) X-MSMail-Priority: Normal X-Mailer: AspMail 4.0 4.03 (SMT492C4AF) Subject: How to calculate row sizes MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Message-ID: X-OriginalArrivalTime: 03 Jan 2005 18:53:54.0078 (UTC) FILETIME=[926E73E0:01C4F1C5] X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.235 tagged_above=0 required=5 tests=INVALID_DATE X-Spam-Level: X-Archive-Number: 200501/16 X-Sequence-Number: 15875 I need some help. I need to calculate the max amount of space a row in each of my tables = will take. However, I am having a difficult time finding the = information needed to do this. =20 Would someone please be so kind as to point me to a listing of field = type sizes, and also how to calculate the space usage of the associated = indexes. thanks, revoohc