From: | "Lee Wu" <Lwu(at)mxlogic(dot)com> |
---|---|
To: | <chen(at)musc(dot)edu>, "pgsql-admin list" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: is this normal? |
Date: | 2005-04-04 14:25:49 |
Message-ID: | ECAB83AA52BCC043A0E24BBC00001024D2E6EA@mxhq-exch.corp.mxlogic.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
How do you do dump? With compressness?
Do you have a lot of dead tuples/index entries?
-----Original Message-----
From: pgsql-admin-owner(at)postgresql(dot)org
[mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of Chuming Chen
Sent: Monday, April 04, 2005 7:27 AM
To: pgsql-admin list
Subject: [ADMIN] is this normal?
Dear all,
I have a postgresql database.
"du -ks /var/lib/pgsql/data" gives me the following disk usage
45592808 /var/lib/pgsql/data (about 44G)
But after I did a pg_dump, the dump file only has the size of 5.9 G.
Thank you for your kind reply and comments.
--
Chuming Chen
System Administrator
NHLBI Proteomics Center
Medical University of South Carolina
135 Cannon Street, Suite 303
Charleston SC 29425
Tel: 843-792-1555 (O)
Fax: 843-876-1126
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
message can get through to the mailing list cleanly
From | Date | Subject | |
---|---|---|---|
Next Message | eanxgeek | 2005-04-04 14:27:55 | Having performance problems. |
Previous Message | Chuming Chen | 2005-04-04 13:27:25 | is this normal? |