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