Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade - Mailing list pgsql-performance

From Andres Freund
Subject Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade
Date
Msg-id 20171122165619.i3zqvqz6bbqyxff2@alap3.anarazel.de
Whole thread Raw
In response to Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade  (Matthew Hall <mhall@mhcomputing.net>)
List pgsql-performance
Tree view 
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 by date:

Previous
From: Artur Zając
Date:
Subject: RE: Bad estimates
Next
From: Matthew Hall
Date:
Subject: Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade