Thread: calculation of database size

How can I measure the approximate database size based on row data.
Is there any calculation template?

--
Thanks & Regards
DJ

The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. 
Any review, re-transmission, dissemination or other use of or taking of any action in reliance upon,this information by persons or entities other than the intended recipient is prohibited. 
If you received this in error, please contact the sender and delete the material from your computer. 
Microland takes all reasonable steps to ensure that its electronic communications are free from viruses. 
However, given Internet accessibility, the Company cannot accept liability for any virus introduced by this e-mail or any attachment and you are advised to use up-to-date virus checking software. 

Ignore the previous mail.

How can I measure the approximate database size based on raw* data.
Is there any calculation template?

--
Thanks & Regards
DJ

--
Thanks & Regards

Dhaval Jaiswal | Technical Specialist - Database | Microland Limited
Fax: +91 80 4328 0044. Cell: +91 80953.978.43

www.microland.com
India's leading Infrastructure Management Services Company



-----Original Message-----
From: Jaiswal Dhaval Sudhirkumar
Sent: Thu 12/9/2010 10:05 PM
To: pgsql-general@postgresql.org
Subject: calculation of database size

How can I measure the approximate database size based on row data.
Is there any calculation template?

--
Thanks & Regards
DJ

The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. 
Any review, re-transmission, dissemination or other use of or taking of any action in reliance upon,this information by persons or entities other than the intended recipient is prohibited. 
If you received this in error, please contact the sender and delete the material from your computer. 
Microland takes all reasonable steps to ensure that its electronic communications are free from viruses. 
However, given Internet accessibility, the Company cannot accept liability for any virus introduced by this e-mail or any attachment and you are advised to use up-to-date virus checking software. 

On Thu, Dec 9, 2010 at 8:37 AM, Jaiswal Dhaval Sudhirkumar
<JaiswalDS@microland.com> wrote:
> How can I measure the approximate database size based on raw* data.
> Is there any calculation template?
>
> --
> Thanks & Regards
> DJ

One option:
select pg_size_pretty( pg_database_size( 'yourdatabase' ) );

The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. 
Any review, re-transmission, dissemination or other use of or taking of any action in reliance upon,this information by persons or entities other than the intended recipient is prohibited. 
If you received this in error, please contact the sender and delete the material from your computer. 
Microland takes all reasonable steps to ensure that its electronic communications are free from viruses. 
However, given Internet accessibility, the Company cannot accept liability for any virus introduced by this e-mail or any attachment and you are advised to use up-to-date virus checking software.