How to calculate row sizes

From: "Chris Hoover" <revoohc(at)sermonaudio(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: How to calculate row sizes
Date: 2005-01-03 18:53:25
Message-ID: MAILSERVERqp2T0apMH0000030f@mail.astudios.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Peter Eisentraut 2005-01-03 20:55:20 Re: How to calculate row sizes
Previous Message Bradley Kieser 2005-01-03 18:29:56 Re: Rules on a view overwrite default values. Any way to