big database with very small dump !? - Mailing list pgsql-general

From Joao Ferreira gmail
Subject big database with very small dump !?
Date
Msg-id 1218472204.6620.41.camel@jmf-ubuntu
Whole thread Raw
Responses 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>)
List 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 by date:

Previous
From: Jack Orenstein
Date:
Subject: Re: Unlinked files in PGDATA/base following unclean shutdown
Next
From: Greg Smith
Date:
Subject: Re: 100% CPU pg processes that don't die.