Re: big database with very small dump !?

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