Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade
Дата
Msg-id 20171122165619.i3zqvqz6bbqyxff2@alap3.anarazel.de
обсуждение исходный текст
Ответ на Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade  (Matthew Hall <mhall@mhcomputing.net>)
Список pgsql-performance
Hi,

On 2017-11-22 02:32:45 -0800, Matthew Hall wrote:
> I would say most likely your zlib is screwed up somehow, like maybe it
> didn't get optimized right by the C compiler or something else sucks
> w/ the compression settings. The CPU should easily blast away at that
> faster than disks can read.

Huh? Zlib compresses at a few 10s of MB/s.

Greetings,

Andres Freund


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

Предыдущее
От: Artur Zając
Дата:
Сообщение: RE: Bad estimates
Следующее
От: Matthew Hall
Дата:
Сообщение: Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade