9.4 -> 9.5 dump size reduction

From: Seb <spluque(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: 9.4 -> 9.5 dump size reduction
Date: 2016-02-12 03:52:54
Message-ID: 87a8n637qh.fsf@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2016-02-12 04:48:53 Re: 9.4 -> 9.5 dump size reduction
Previous Message Michael Paquier 2016-02-12 02:53:42 Re: fast refresh materialized view