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
Ответ на
Список
Дерево обсуждения
pg_dump 3 times as slow after 8.4 -> 9.5 upgrade "Henrik Cednert (Filmlance)" <henrik.cednert@filmlance.se>
Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade Patrick KUI-LI <pkuili@hipay.com>
Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade "Henrik Cednert (Filmlance)" <henrik.cednert@filmlance.se>
Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade Gunther <raj@gusw.net>
Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade Laurenz Albe <laurenz.albe@cybertec.at>
Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade Claudio Freire <klaussfreire@gmail.com>
Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade Robert Haas <robertmhaas@gmail.com>
Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade "Henrik Cednert (Filmlance)" <henrik.cednert@filmlance.se>
Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade "Henrik Cednert (Filmlance)" <henrik.cednert@filmlance.se>
Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade "Henrik Cednert (Filmlance)" <henrik.cednert@filmlance.se>
Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade "Henrik Cednert (Filmlance)" <henrik.cednert@filmlance.se>
Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade Matthew Hall <mhall@mhcomputing.net>
Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade Andres Freund <andres@anarazel.de>
Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade "Henrik Cednert (Filmlance)" <henrik.cednert@filmlance.se>
Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade "Henrik Cednert (Filmlance)" <henrik.cednert@filmlance.se>
Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade Matthew Hall <mhall@mhcomputing.net>
Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade "Henrik Cednert (Filmlance)" <henrik.cednert@filmlance.se>
RE: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade Igor Neyman <ineyman@perceptron.com>
Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade "Henrik Cednert (Filmlance)" <henrik.cednert@filmlance.se>
RE: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade Igor Neyman <ineyman@perceptron.com>
Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade "Henrik Cednert (Filmlance)" <henrik.cednert@filmlance.se>
RE: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade Igor Neyman <ineyman@perceptron.com>
Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade "Henrik Cednert (Filmlance)" <henrik.cednert@filmlance.se>
RE: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade Igor Neyman <ineyman@perceptron.com>
Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade Shaul Dar <shauldar@gmail.com>
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
Дата:
FAQ