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-

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend