Hi Duan,
perhaps you can go the way via some system functions like:
## list tables and their size
SELECT relname AS table_name,
pg_size_pretty(pg_relation_size(oid)) AS table_sz,
pg_size_pretty(pg_total_relation_size(oid)) AS
total_sz
FROM pg_class
WHERE relkind = 'r'
ORDER BY pg_relation_size(oid) DESC;
## list db's and size
SELECT datname AS db_name,
pg_size_pretty(pg_database_size(oid)) AS db_size
FROM pg_database
ORDER BY pg_database_size(oid) DESC;
hope that helps......::GERD::......
Am 22.05.2008 um 03:08 schrieb Duan Ligong:
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
--
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
