| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Henrik Cednert (Filmlance)" <henrik(dot)cednert(at)filmlance(dot)se> |
| Cc: | "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 21:01:20 |
| Message-ID: | 20863.1511298080@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
"Henrik Cednert (Filmlance)" <henrik(dot)cednert(at)filmlance(dot)se> writes:
> I'm not sure if I can attach screenshots here. Trying, screenshot from instruments after running for a few mins.
It looks like practically all of pg_dump's time is going into deflate(),
ie zlib. I don't find that terribly surprising in itself, but it offers
no explanation for why you'd see a slowdown --- zlib isn't even our
code, nor has it been under active development for a long time, so
presumably 8.4 and 9.5 would have used the same version. Perhaps you
were doing the 8.4 dump without compression enabled?
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Henrik Cednert (Filmlance) | 2017-11-22 03:48:09 | Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade |
| Previous Message | Henrik Cednert (Filmlance) | 2017-11-21 18:59:08 | Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade |