9.4 -> 9.5 dump size reduction - Mailing list pgsql-general

From Seb
Subject 9.4 -> 9.5 dump size reduction
Date
Msg-id 87a8n637qh.fsf@gmail.com
Whole thread Raw
Responses Re: 9.4 -> 9.5 dump size reduction  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Hello,

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?!

Thanks,

--
Seb

pgsql-general by date:

Previous
From: Michael Paquier
Date:
Subject: Re: fast refresh materialized view
Next
From: Tom Lane
Date:
Subject: Re: 9.4 -> 9.5 dump size reduction