From: | Jason DiCioccio <geniusj(at)gmail(dot)com> |
---|---|
To: | chen(at)musc(dot)edu |
Cc: | pgsql-admin list <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: is this normal? |
Date: | 2005-04-04 14:46:24 |
Message-ID: | 89bc2a040504040746662b6e62@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Greetings,
On Apr 4, 2005 9:27 AM, Chuming Chen <chen(at)musc(dot)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-
From | Date | Subject | |
---|---|---|---|
Next Message | Chuming Chen | 2005-04-04 14:51:46 | Re: is this normal? |
Previous Message | eanxgeek | 2005-04-04 14:27:55 | Having performance problems. |