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

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