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.

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



---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

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

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

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



---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Am Dienstag, 4. Januar 2005 03:10 schrieb Chris Hoover:
> 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.

The storage requirements for each column type are quite evidently displayed in
the documentation about the data types. The overhead is shown in the FAQ.
If you want more precise values, create a table, fill it with values, run
VACUUM FULL, and look at the file system size. That's the only way you can
be sure.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match