Re: [GENERAL] pg_dump and database size question

2011-01-06 Thread Adrian Klaver
On Thursday 06 January 2011 5:58:13 am Birta Levente wrote: > 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. > > t

Re: [GENERAL] pg_dump and database size question

2011-01-06 Thread Gary Chambers
Birta, After pg_dump of the database, the size increased with aprox 200MB ... How are you dumping the database? Are you using -Fc on the command line, or are you dumping to a text file? I have nothing to quantify my comment, but it seems possible that with a database of that size, the additi

[GENERAL] pg_dump and database size question

2011-01-06 Thread Birta Levente
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 -- Sent via pgsql-general mailing list (pgsql-