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.
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 |