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

From: marcin mank <marcin(dot)mank(at)gmail(dot)com>
To: Aleksey Tsalolikhin <atsaloli(dot)tech(at)gmail(dot)com>
Cc: 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 15:24:09
Message-ID: AANLkTikWfbz+t4YMuarTn2BUeCaV6RFQauiOpPVY+Ry=@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 ?

Greetings
Marcin

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message gvim 2011-02-24 15:49:59 Recreate database but old tables still present
Previous Message Sim Zacks 2011-02-24 14:10:58 Re: ldap authentication multiple ou objects