Greetings, On Apr 4, 2005 9:27 AM, Chuming Chen <chen@xxxxxxxx> 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-
