pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedis this normal?
4+ messages / 3 participants
[nested] [flat]
* is this normal?
@ 2005-04-04 13:27 Chuming Chen <chen@musc.edu>
2005-04-04 14:46 ` Re: is this normal? Jason DiCioccio <geniusj@gmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: Chuming Chen @ 2005-04-04 13:27 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: is this normal?
2005-04-04 13:27 is this normal? Chuming Chen <chen@musc.edu>
@ 2005-04-04 14:46 ` Jason DiCioccio <geniusj@gmail.com>
0 siblings, 0 replies; 4+ messages in thread
From: Jason DiCioccio @ 2005-04-04 14:46 UTC (permalink / raw)
To: chen@musc.edu; +Cc: pgsql-admin
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-
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: is this normal?
@ 2005-04-04 14:25 Lee Wu <Lwu@mxlogic.com>
2005-04-04 14:51 ` Re: is this normal? Chuming Chen <chen@musc.edu>
0 siblings, 1 reply; 4+ messages in thread
From: Lee Wu @ 2005-04-04 14:25 UTC (permalink / raw)
To: chen@musc.edu; 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@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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: is this normal?
2005-04-04 14:25 Re: is this normal? Lee Wu <Lwu@mxlogic.com>
@ 2005-04-04 14:51 ` Chuming Chen <chen@musc.edu>
0 siblings, 0 replies; 4+ messages in thread
From: Chuming Chen @ 2005-04-04 14:51 UTC (permalink / raw)
To: Lee Wu <Lwu@mxlogic.com>; +Cc: 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@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
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2005-04-04 14:51 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-04-04 13:27 is this normal? Chuming Chen <chen@musc.edu>
2005-04-04 14:46 ` Jason DiCioccio <geniusj@gmail.com>
2005-04-04 14:25 Re: is this normal? Lee Wu <Lwu@mxlogic.com>
2005-04-04 14:51 ` Chuming Chen <chen@musc.edu>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox