Re: How to calculate row sizes - Mailing list pgsql-admin

From Chris Hoover
Subject Re: How to calculate row sizes
Date
Msg-id 41D9FB09.3060107@sermonaudio.com
Whole thread Raw
In response to Re: How to calculate row sizes  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: How to calculate row sizes  (Peter Eisentraut <peter_e@gmx.net>)
List 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



pgsql-admin by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: How to calculate row sizes
Next
From: Peter Eisentraut
Date:
Subject: Re: How to calculate row sizes