Re: database is bigger after dump/restore - why? (60 GB to 109 GB)

From: Aleksey Tsalolikhin <atsaloli(dot)tech(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: database is bigger after dump/restore - why? (60 GB to 109 GB)
Date: 2011-02-24 23:34:02
Message-ID: AANLkTikvs69NceVXiF9jNK_p1oA8DSAb=ZeHBF6=jLT5@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi. We're running Postgres 8.4.4 everywhere.

I already have a pg_dump -Fc of the big table from the source, now
I am running a pg_dump -Fc on the recipient, to see if the size is different.

Then I will run a pg_dump as text, so I can diff the two files if they are
different in size.

Thanks!!
Aleksey

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Aleksey Tsalolikhin 2011-02-24 23:38:51 pg_dump makes our system unusable - any way to pg_dump in the middle of the day? (postgres 8.4.4)
Previous Message Adrian Klaver 2011-02-24 21:59:00 Re: database is bigger after dump/restore - why? (60 GB to 109 GB)