Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_dump and database size question - Mailing list pgsql-general

From Gary Chambers
Subject Re: pg_dump and database size question
Date
Msg-id alpine.DEB.2.00.1101061118390.32201@port.garychambers.com
Whole thread Raw
In response to pg_dump and database size question  (Birta Levente <blevi.linux@gmail.com>)
List pgsql-general
Tree view 
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 additional overhead
is related to it being a text-based dump file.

-- Gary Chambers

pgsql-general by date:

Previous
From: Scott Ribe
Date:
Subject: Re: UUID column as pimrary key?
Next
From: Anthony
Date:
Subject: Re: UUID column as pimrary key?