Calculating size of the database tables

From: akuppachi(at)hss(dot)hns(dot)com
To: pgsql-admin(at)postgresql(dot)org
Subject: Calculating size of the database tables
Date: 2004-06-10 10:27:53
Message-ID: OFBB94A294.8DCDB8DE-ON65256EAF.0038BA46-65256EAF.003982D8@hss.hns.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

My application uses several database tables on Postgres backend and either
a postgres or an ODBC front-end. I need to calculate the total hard disk
space occupied by the database for my application. I started out by
calculating the size of each record (row) in each table and multiplying
that with the max. expected number of entries to get this data, but
realized soon that this will not give me the full size, since many of the
tables are indexed, so index size must also be considered. Apart from that,
i read somewhere that Postgres stores 4 extra bytes per character field.

I would appreciate any pointers to finding out the correct size occupied by
my database tables. Will the physical size of the "data" folder (as given
by 'ls' command) give me the true size, or is there any other sql command
that i can use to get this information? I am using PostgreSQL, version
7.4.1 server libraries.

TIA,
Aparna.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Devrim GUNDUZ 2004-06-10 10:55:54 Re: Calculating size of the database tables
Previous Message lise chhay 2004-06-10 10:13:37 My script inst/init-base didn't run