Re: pg_dump and database size question

From: Gary Chambers <gwchamb(at)gwcmail(dot)com>
To: Birta Levente <blevi(dot)linux(at)gmail(dot)com>
Cc: PostgreSQL general <pgsql-general(at)postgresql(dot)org>
Subject: Re: pg_dump and database size question
Date: 2011-01-06 16:21:18
Message-ID: alpine.DEB.2.00.1101061118390.32201@port.garychambers.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Anthony 2011-01-06 16:22:18 Re: UUID column as pimrary key?
Previous Message Scott Ribe 2011-01-06 15:59:56 Re: UUID column as pimrary key?