Обсуждение: 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
How do you do dump? With compressness?
Do you have a lot of dead tuples/index entries?
-----Original Message-----
From: pgsql-admin-owner@postgresql.org
[mailto:pgsql-admin-owner@postgresql.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@postgresql.org so that your
message can get through to the mailing list cleanly
Greetings, On Apr 4, 2005 9:27 AM, Chuming Chen <chen@musc.edu> wrote: > 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. I'd guess most of this space is going to your indexes. If you want to drop the space, I'd drop/recreate the indexes and do a VACUUM FULL. Note that these can both be intrusive and should be done during a maintenance period. Regards, -JD-
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@postgresql.org >[mailto:pgsql-admin-owner@postgresql.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