Postgres Pro
Downloads
Home   >   mailing lists

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

From Richard Huxton
Subject Re: database is bigger after dump/restore - why? (60 GB to 109 GB)
Date
Msg-id 4D669217.2090504@archonet.com
Whole thread Raw
In response to Re: database is bigger after dump/restore - why? (60 GB to 109 GB)  (marcin mank <marcin.mank@gmail.com>)
Responses Re: database is bigger after dump/restore - why? (60 GB to 109 GB)
List pgsql-general
Tree view 
On 24/02/11 15:24, marcin mank wrote:
> On Tue, Feb 22, 2011 at 9:44 PM, Aleksey Tsalolikhin
> <atsaloli.tech@gmail.com>  wrote:
>
>> Most of our data is in a single table, which on the old server is 50 GB in
>> size and on the new server is 100 GB in size.
>>
>
> Maybe the table the on new server has fillfactor less than 100 ?

That would be my immediate guess. Someone changed the fillfactor on the
table - that won't affect the existing data but will affect a restore.

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: Guillaume Lelarge
Date:
Subject: Re: Recreate database but old tables still present
Next
From: "Gauthier, Dave"
Date:
Subject: regexp problem