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 по дате отправления: