Re: big database with very small dump !?

[Vlad Kosilov <vkosilov@xxxxxxxxxxx>]

I'd do
du -sh /var/pgsql/data/base
rather then /var/pgsql/data
depending on how your pgsql server logging is setup, there are other 
folders and/or files that might take considerable disk space under 
./data/ you may want to exclude those. I find this query useful for 
something like this as well:

select datname,pg_size_pretty(pg_database_size(oid)) from pg_database ;

V.

Joao Ferreira gmail wrote:
> 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
>         
>         
>
>
>