pg_dump and database size question

From: Birta Levente <blevi(dot)linux(at)gmail(dot)com>
To: PostgreSQL general <pgsql-general(at)postgresql(dot)org>
Subject: pg_dump and database size question
Date: 2011-01-06 13:58:13
Message-ID: 4D25CA75.30100@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I have postgres 9.0.2 server with a 2.4GB database.
After pg_dump of the database, the size increased with aprox 200MB ... why?
I make some tests and the total_relation_size is increased, but the
relation_size not.

thanks

Birta Levente

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Ribe 2011-01-06 14:28:04 Re: UUID column as pimrary key?
Previous Message Peter Geoghegan 2011-01-06 13:39:51 Re: linux server configuration