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

On Mon, 2008-08-11 at 12:43 -0700, Vlad Kosilov wrote:
> ./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 ;
>

Hello Vlad,

I ran your query and I got the 9Gigas!

I guess it should be related to index bloating, then. Do you agree ?

thx
Joao



postgres=# select datname,pg_size_pretty(pg_database_size(oid)) from
pg_database;
    datname    | pg_size_pretty
---------------+----------------
 postgres      | 3617 kB
 egbert        | 9585 MB
 asterisk      | 3993 kB
 turba         | 3673 kB
 edgereporting | 3617 kB
 template1     | 3617 kB
 template0     | 3537 kB
(7 rows)

postgres=#


> 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
> >
> >
> >
> >
> >
>