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 .
In response to
pgsql-admin by date
|Next:||From: Duan Ligong||Date: 2008-05-22 01:08:33|
|Subject: Re: ]To estimate the size of db|
|Previous:||From: Scott Marlowe||Date: 2008-05-21 19:07:07|
|Subject: Re: Trouble with recovering disc space|