Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux