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

Поиск
Список
Период
Сортировка
От Henrik Cednert (Filmlance)
Тема Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade
Дата
Msg-id C9386B1B-EFC1-470D-A265-52938FCB25BF@filmlance.se
обсуждение исходный текст
Ответ на RE: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade  (Igor Neyman <ineyman@perceptron.com>)
Ответы RE: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade
Список pgsql-performance
Дерево обсуждения
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@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

В списке pgsql-performance по дате отправления: