Re: How to calculate row sizes

From: "Chris Hoover" <revoohc(at)sermonaudio(dot)com>
To: "Peter Eisentraut" <peter_e(at)gmx(dot)net>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: How to calculate row sizes
Date: 2005-01-04 02:10:17
Message-ID: 41D9FB09.3060107@sermonaudio.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Peter Eisentraut 2005-01-04 08:50:33 Re: How to calculate row sizes
Previous Message Peter Eisentraut 2005-01-03 20:55:20 Re: How to calculate row sizes