big database with very small dump !?
От | Joao Ferreira gmail |
---|---|
Тема | big database with very small dump !? |
Дата | |
Msg-id | 1218472204.6620.41.camel@jmf-ubuntu обсуждение исходный текст |
Ответы |
Re: big database with very small dump !?
Re: big database with very small dump !? Re: big database with very small dump !? |
Список | 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
В списке pgsql-general по дате отправления: