| From: | Igor Neyman <ineyman(at)perceptron(dot)com> |
|---|---|
| To: | "Henrik Cednert (Filmlance)" <henrik(dot)cednert(at)filmlance(dot)se>, "pgsql-performance(at)lists(dot)postgresql(dot)org" <pgsql-performance(at)lists(dot)postgresql(dot)org> |
| Subject: | RE: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade |
| Date: | 2017-11-21 16:34:03 |
| Message-ID: | CY1PR17MB04583F0502E293260A8E723BDA230@CY1PR17MB0458.namprd17.prod.outlook.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Henrik Cednert (Filmlance) | 2017-11-21 16:37:13 | Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade |
| Previous Message | Henrik Cednert (Filmlance) | 2017-11-21 16:27:12 | Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade |