Re: 9.4 -> 9.5 dump size reduction

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: 9.4 -> 9.5 dump size reduction
Дата
Msg-id 24872.1455252533@sss.pgh.pa.us
обсуждение исходный текст
Ответ на 9.4 -> 9.5 dump size reduction  (Seb <spluque@gmail.com>)
Ответы Re: 9.4 -> 9.5 dump size reduction  ("FarjadFarid\(ChkNet\)" <farjad.farid@checknetworks.com>)
Список pgsql-general
Seb <spluque@gmail.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


В списке pgsql-general по дате отправления:

Предыдущее
От: Seb
Дата:
Сообщение: 9.4 -> 9.5 dump size reduction
Следующее
От: Pavel Stehule
Дата:
Сообщение: Re: XMLEXISTS on legacy XML with malformed xmlns