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

Поиск
Список
Период
Сортировка
От Igor Neyman
Тема RE: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade
Дата
Msg-id CY1PR17MB04583F0502E293260A8E723BDA230@CY1PR17MB0458.namprd17.prod.outlook.com
обсуждение исходный текст
Ответ на Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade  ("Henrik Cednert (Filmlance)" <henrik.cednert@filmlance.se>)
Ответы Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade  ("Henrik Cednert (Filmlance)" <henrik.cednert@filmlance.se>)
Список pgsql-performance
Дерево обсуждения

 

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 по дате отправления:

Предыдущее
От: "Henrik Cednert (Filmlance)"
Дата:
Сообщение: 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