Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group