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

From Peter Eisentraut
Subject Re: How to calculate row sizes
Date
Msg-id 200501040950.34265.peter_e@gmx.net
Whole thread Raw
In response to Re: How to calculate row sizes  ("Chris Hoover" <revoohc@sermonaudio.com>)
List pgsql-admin
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/

pgsql-admin by date:

Previous
From: "Chris Hoover"
Date:
Subject: Re: How to calculate row sizes
Next
From: Pallav Kalva
Date:
Subject: max_fsm_relations