| 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 17:01:27 |
| Message-ID: | 7442.1511283687@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
"Henrik Cednert (Filmlance)" <henrik(dot)cednert(at)filmlance(dot)se> writes:
> The last pg_dump with 8.4 took 212 minutes and 49 seconds.And now with 9.5 the very same pg_dump takes 644 minutes and 40 seconds. To it takes about three times as long now and I have no idea to why. Nothing in the system or hardware other than the pgsql upgrade have change.
Can you get a profile of where the machine is spending its time during the
dump run? On Linux I'd recommend "perf", but on macOS, hmm ...
You could use Activity Monitor, but as far as I can see that just captures
short-duration snapshots, which might not be representative of a 10-hour
run. XCode's Instruments feature would probably be better about giving
a full picture, but it has a steep learning curve.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andres Freund | 2017-11-21 18:16:56 | Re: Using GROUPING SETS with more than one set disables predicate pushdown? |
| Previous Message | Igor Neyman | 2017-11-21 16:57:30 | RE: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade |