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

From: Andres Freund <andres(at)anarazel(dot)de>
To: Matthew Hall <mhall(at)mhcomputing(dot)net>
Cc: "Henrik Cednert (Filmlance)" <henrik(dot)cednert(at)filmlance(dot)se>, "pgsql-performance(at)lists(dot)postgresql(dot)org" <pgsql-performance(at)lists(dot)postgresql(dot)org>
Subject: Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade
Date: 2017-11-22 16:56:19
Message-ID: 20171122165619.i3zqvqz6bbqyxff2@alap3.anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Matthew Hall 2017-11-22 19:52:11 Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade
Previous Message Artur Zając 2017-11-22 16:52:30 RE: Bad estimates