9.4 -> 9.5 dump size reduction

Поиск
Список
Период
Сортировка
От Seb
Тема 9.4 -> 9.5 dump size reduction
Дата
Msg-id 87a8n637qh.fsf@gmail.com
обсуждение исходный текст
Ответы Re: 9.4 -> 9.5 dump size reduction  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: fast refresh materialized view
Следующее
От: Tom Lane
Дата:
Сообщение: Re: 9.4 -> 9.5 dump size reduction