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

RAID6. Doing disk test I have 1000MB/sec write and 1200MB/sec read.

--
Henrik Cednert
cto | compositor

Filmlance International
mobile [ + 46 (0)704 71 89 54 ]
skype [ cednert ]

On 21 Nov 2017, at 17:34, Igor Neyman <ineyman(at)perceptron(dot)com<mailto:ineyman(at)perceptron(dot)com>> wrote:

From: Henrik Cednert (Filmlance) [mailto:henrik(dot)cednert(at)filmlance(dot)se]
Sent: Tuesday, November 21, 2017 11:27 AM
To: pgsql-performance(at)lists(dot)postgresql(dot)org<mailto:pgsql-performance(at)lists(dot)postgresql(dot)org>
Subject: Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade

Ahh! Nice catch Igor. Thanks. =)

Will try and see if resolve can read that back in.

Still very curious about the 3x slowdown in 9.5 pg_dump though.

--
Henrik Cednert
cto | compositor

Filmlance International

Basically, you are dumping 40GB of data.
I’d say even 212 minutes under 8.4 version was too slow.
What kind of RAID is it? RAID1/RAID10/RAID5?

Regards,
Igor Neyman