From: | Chuming Chen <chen(at)musc(dot)edu> |
---|---|
To: | Lee Wu <Lwu(at)mxlogic(dot)com> |
Cc: | pgsql-admin list <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: is this normal? |
Date: | 2005-04-04 14:51:46 |
Message-ID: | 42515482.7080701@musc.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Lee Wu wrote:
>How do you do dump? With compressness?
>
>
I used "pg_dump -o dbname"
>Do you have a lot of dead tuples/index entries?
>
>
>
>
How can I check this and remove them?
>-----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
From | Date | Subject | |
---|---|---|---|
Next Message | David A. Leedom | 2005-04-04 15:14:35 | Re: Having performance problems. |
Previous Message | Jason DiCioccio | 2005-04-04 14:46:24 | Re: is this normal? |