Re: calculation of database size

From: bricklen <bricklen(at)gmail(dot)com>
To: Jaiswal Dhaval Sudhirkumar <JaiswalDS(at)microland(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: calculation of database size
Date: 2010-12-09 21:24:39
Message-ID: AANLkTim_-qymdqYdTdHf9SovRoPMJQKsmT+oX-Q4fh9+@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Dec 9, 2010 at 8:37 AM, Jaiswal Dhaval Sudhirkumar
<JaiswalDS(at)microland(dot)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' ) );

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dmitriy Igrishin 2010-12-09 22:10:10 Fwd: Extended query protocol and exact types matches.
Previous Message Josh Kupershmidt 2010-12-09 19:30:09 monitoring warm standby lag in 8.4?