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

On 21 Nov 2017, at 17:34, Igor Neyman <ineyman@perceptron.com> wrote:

 

From: Henrik Cednert (Filmlance) [mailto:henrik.cednert@filmlance.se] 
Sent: Tuesday, November 21, 2017 11:27 AM
To: pgsql-performance@lists.postgresql.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