pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedHow to calculate row sizes
4+ messages / 2 participants
[nested] [flat]
* How to calculate row sizes
@ 1970-01-01 00:00 Chris Hoover <revoohc@sermonaudio.com>
0 siblings, 1 reply; 4+ messages in thread
From: Chris Hoover @ 1970-01-01 00:00 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: How to calculate row sizes
@ 2005-01-03 20:55 Peter Eisentraut <peter_e@gmx.net>
parent: Chris Hoover <revoohc@sermonaudio.com>
0 siblings, 1 reply; 4+ messages in thread
From: Peter Eisentraut @ 2005-01-03 20:55 UTC (permalink / raw)
To: Chris Hoover <revoohc@sermonaudio.com>; +Cc: pgsql-admin
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/
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: How to calculate row sizes
@ 2005-01-04 02:10 Chris Hoover <revoohc@sermonaudio.com>
parent: Peter Eisentraut <peter_e@gmx.net>
0 siblings, 1 reply; 4+ messages in thread
From: Chris Hoover @ 2005-01-04 02:10 UTC (permalink / raw)
To: Peter Eisentraut <peter_e@gmx.net>; +Cc: 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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: How to calculate row sizes
@ 2005-01-04 08:50 Peter Eisentraut <peter_e@gmx.net>
parent: Chris Hoover <revoohc@sermonaudio.com>
0 siblings, 0 replies; 4+ messages in thread
From: Peter Eisentraut @ 2005-01-04 08:50 UTC (permalink / raw)
To: Chris Hoover <revoohc@sermonaudio.com>; +Cc: 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/
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2005-01-04 08:50 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1970-01-01 00:00 How to calculate row sizes Chris Hoover <revoohc@sermonaudio.com>
2005-01-03 20:55 ` Peter Eisentraut <peter_e@gmx.net>
2005-01-04 02:10 ` Chris Hoover <revoohc@sermonaudio.com>
2005-01-04 08:50 ` Peter Eisentraut <peter_e@gmx.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox