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

From: Richard Huxton <dev(at)archonet(dot)com>
To: marcin mank <marcin(dot)mank(at)gmail(dot)com>
Cc: Aleksey Tsalolikhin <atsaloli(dot)tech(at)gmail(dot)com>, 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 17:15:03
Message-ID: 4D669217.2090504@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 24/02/11 15:24, marcin mank wrote:
> On Tue, Feb 22, 2011 at 9:44 PM, Aleksey Tsalolikhin
> <atsaloli(dot)tech(at)gmail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Gauthier, Dave 2011-02-24 18:25:43 regexp problem
Previous Message Guillaume Lelarge 2011-02-24 15:55:45 Re: Recreate database but old tables still present