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@xxxxxxxxxxxxxxxxxx
----- Original Message -----
From: "Scott Marlowe" <scott.marlowe@xxxxxxxxx>
To: "Duan Ligong" <l-duan@xxxxxxxxxxxxxxxxxx>
Cc: <pgsql-admin@xxxxxxxxxxxxxx>
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@xxxxxxxxxxxxxxxxxx>
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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
