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 !?  (Greg Smith <gsmith@gregsmith.com>)
Re: big database with very small dump !?  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Re: big database with very small dump !?  (Vlad Kosilov <vkosilov@contigo.com>)
Список 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 по дате отправления:

Предыдущее
От: Jack Orenstein
Дата:
Сообщение: Re: Unlinked files in PGDATA/base following unclean shutdown
Следующее
От: Greg Smith
Дата:
Сообщение: Re: 100% CPU pg processes that don't die.