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 5C5D73A3B5B for ; Tue, 4 Jan 2005 02:07:46 +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 28699-08 for ; Tue, 4 Jan 2005 02:07:23 +0000 (GMT) Received: from mail.astudios.com (ns1.astudios.com [66.49.77.3]) by svr1.postgresql.org (Postfix) with ESMTP id 9D5203A1923 for ; Tue, 4 Jan 2005 02:07:25 +0000 (GMT) thread-index: AcTyAjeKsc6ZCpDEQwKrVFZWXKjCSg== Content-Class: urn:content-classes:message Importance: normal Received: from [192.168.1.103] ([24.211.121.176]) by mail.astudios.com with Microsoft SMTPSVC(6.0.3790.211); Mon, 3 Jan 2005 21:08:00 -0500 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.181 Message-ID: <41D9FB09.3060107@sermonaudio.com> Date: Mon, 03 Jan 2005 21:10:17 -0500 From: "Chris Hoover" User-Agent: Mozilla Thunderbird 1.0 (X11/20041227) X-Accept-Language: en-us, en MIME-Version: 1.0 To: "Peter Eisentraut" Cc: Subject: Re: How to calculate row sizes References: <200501032155.20181.peter_e@gmx.net> In-Reply-To: <200501032155.20181.peter_e@gmx.net> X-Enigmail-Version: 0.89.5.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: text/plain; format=flowed; charset="ISO-8859-1" Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 04 Jan 2005 02:08:00.0828 (UTC) FILETIME=[378117C0:01C4F202] 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/18 X-Sequence-Number: 15877 Peter Eisentraut wrote: >Chris Hoover wrote: > > >>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. >> >> > >FAQ 4.6 > > > This faq is not very helpful. I really need to know the values for each type of column, and then how much to add for the overhead. It only gives a single example, and does not address the index size. Nor does it give the storage size for the various column types. Anything better out there, or has anyone have a script/spreadsheet that will calculate this? Thanks