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 : [EMAIL PROTECTED]
----- Original Message -----
From: "Scott Marlowe" <[EMAIL PROTECTED]>
To: "Duan Ligong" <[EMAIL PROTECTED]>
Cc: <pgsql-admin@postgresql.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 <[EMAIL PROTECTED]>
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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
