Got the link.
http://wiki.postgresql.org/wiki/FAQ#What_is_the_maximum_size_for_a_row.2C_a_table.2C_and_a_database.3F
--
Thanks & Regards
DJ
From: Jaiswal Dhaval Sudhirkumar
Sent: Thu 12/9/2010 10:07 PM
To: Jaiswal Dhaval Sudhirkumar; pgsql-general@postgresql.
On Thu, Dec 9, 2010 at 8:37 AM, Jaiswal Dhaval Sudhirkumar
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' ) );
--
Sent via pgsql-
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.mic
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-tra
