| From: | Joao Ferreira gmail <joao(dot)miguel(dot)c(dot)ferreira(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | big database with very small dump !? |
| Date: | 2008-08-11 16:30:04 |
| Message-ID: | 1218472204.6620.41.camel@jmf-ubuntu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hello all,
I'm finding it very strange that my pg takes 9Giga on disk but
pg_dumpall produces a 250Mega dump. 'VACUUM FULL' was executed
yesterday.
Is this normal ? Should I be worried ?
details bellow:
------------------------------------------
# pg_dumpall --oids --clean > pg_dumpall.sql
# ls -lh
total 232M
-rw-r--r-- 1 postgres postgres 231M Aug 11 15:46
pg_dumpall.sql
# du -sh /var/pgsql/data/
9.4G /var/pgsql/data
------------------------------------------
thx
joao
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Smith | 2008-08-11 16:41:02 | Re: 100% CPU pg processes that don't die. |
| Previous Message | Jack Orenstein | 2008-08-11 16:13:00 | Re: Unlinked files in PGDATA/base following unclean shutdown |