Postgres Pro
Downloads
Home   >   mailing lists

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

From Greg Smith
Subject Re: big database with very small dump !?
Date
Msg-id Pine.GSO.4.64.0808111243570.25081@westnet.com
Whole thread Raw
In response to big database with very small dump !?  (Joao Ferreira gmail <joao.miguel.c.ferreira@gmail.com>)
Responses Re: big database with very small dump !?  (Joao Ferreira gmail <joao.miguel.c.ferreira@gmail.com>)
Re: big database with very small dump !?  (Joao Ferreira gmail <joao.miguel.c.ferreira@gmail.com>)
List pgsql-general
Tree view 
On Mon, 11 Aug 2008, Joao Ferreira gmail wrote:

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

If you've been running VACUUM FULL, it's probably so-called "index bloat".
Try running the query at http://wiki.postgresql.org/wiki/Disk_Usage to
figure out where all your space has gone inside the database.

--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD

pgsql-general by date:

Previous
From: aravind chandu
Date:
Subject: How to calculate number of rows per page in postgresql
Next
From: "Scott Marlowe"
Date:
Subject: Re: big database with very small dump !?