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

From Joao Ferreira gmail
Subject Re: big database with very small dump !?
Date
Msg-id 1218532866.6460.4.camel@jmf-ubuntu
Whole thread Raw
In response to Re: big database with very small dump !?  (Vlad Kosilov <vkosilov@contigo.com>)
Responses Re: big database with very small dump !?  (Bill Moran <wmoran@collaborativefusion.com>)
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
> >
> >
> >
> >
> >
>


pgsql-general by date:

Previous
From: Sim Zacks
Date:
Subject: Re: Can I search for text in a function?
Next
From: Joao Ferreira gmail
Date:
Subject: Re: big database with very small dump !?