pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
How 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