SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-10-2008, 12:39 AM
| ||||
| ||||
 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      |
|
04-10-2008, 12:39 AM
| ||||
| ||||
| Re: is this normal? 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 |
Linear Mode
