Re: big database with very small dump !?

From: Greg Smith <gsmith(at)gregsmith(dot)com>
To: Joao Ferreira gmail <joao(dot)miguel(dot)c(dot)ferreira(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: big database with very small dump !?
Date: 2008-08-11 16:45:18
Message-ID: Pine.GSO.4.64.0808111243570.25081@westnet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)gregsmith(dot)com http://www.gregsmith.com Baltimore, MD

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2008-08-11 16:58:05 Re: big database with very small dump !?
Previous Message aravind chandu 2008-08-11 16:41:47 How to calculate number of rows per page in postgresql