Skip site navigation (1) Skip section navigation (2)

Re: ]To estimate the size of db

From: "Duan Ligong" <l-duan(at)zd(dot)cnes(dot)jp(dot)nec(dot)com>
To: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: ]To estimate the size of db
Date: 2008-05-22 01:08:33
Message-ID: 00ba01c8bba8$5b402750$f623480a@nsl.ad.nec.co.jp (view raw or flat)
Thread:
Lists: pgsql-admin
Hi, Scott

Thanks for your reply.

> There's also the old fashioned way:

I mean I want to estimate the size of the space which the db will occupy.
Now there is no db.

> sudo su - postgres
> cd $PGDATA  # or wherever you point with -D on startup
> du -sh .

Regards
Duan
--
Duan Ligong
TEL   :  0561-75-1925-6201
           800-81-569-6201
E-Mail : l-duan(at)zd(dot)cnes(dot)jp(dot)nec(dot)com
----- Original Message ----- 
From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "Duan Ligong" <l-duan(at)zd(dot)cnes(dot)jp(dot)nec(dot)com>
Cc: <pgsql-admin(at)postgresql(dot)org>
Sent: Thursday, May 22, 2008 4:08 AM
Subject: Re: [ADMIN] [Admin]To estimate the size of db


> On Wed, May 14, 2008 at 7:33 PM, Duan Ligong <l-duan(at)zd(dot)cnes(dot)jp(dot)nec(dot)com> 
> wrote:
>>
>> Hi, all
>>
>> Is there a way to estimate the size of the space which a postgresql 
>> database
>> occupies? or the max size of db?
>>
>> I know there are a lot of factors, such as the frequency
>> of updating, data size, which affects the size of db and it seems 
>> difficult
>> to estimate it precisely.
>
> There's also the old fashioned way:
>
> sudo su - postgres
> cd $PGDATA  # or wherever you point with -D on startup
> du -sh .
>
> -- 
> Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
> 


In response to

Responses

pgsql-admin by date

Next:From: Shane AmblerDate: 2008-05-22 06:34:19
Subject: Re: ]To estimate the size of db
Previous:From: Scott MarloweDate: 2008-05-21 19:08:29
Subject: Re: [Admin]To estimate the size of db

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group