Re: 9.4 -> 9.5 dump size reduction

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Seb <spluque(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: 9.4 -> 9.5 dump size reduction
Date: 2016-02-12 04:48:53
Message-ID: 24872.1455252533@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Seb <spluque(at)gmail(dot)com> writes:
> I recently upgraded a server from 9.4 to 9.5 (Debian) via
> pg_upgradecluster. The upgrade finished well, and so far the databases
> in the upgraded cluster seem in good form. However, I noticed a
> dramatic reduction in the size of the dump created by the new server.
> One of the databases was 34G when dumped by the 9.4 server is now dumped
> at 1.1G in the new 9.5 version (using pg_dump -Fc in both cases). What
> has caused such remarkable improvement?!

That seems really fishy. Better check to see if all your data
is still there :-(

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2016-02-12 04:49:29 Re: XMLEXISTS on legacy XML with malformed xmlns
Previous Message Seb 2016-02-12 03:52:54 9.4 -> 9.5 dump size reduction