From: Tom Lane <tgl@sss.pgh.pa.us>
To: Henrik Cednert (Filmlance) <henrik.cednert@filmlance.se>
Cc: pgsql-performance@lists.postgresql.org <pgsql-performance@lists.postgresql.org>
Subject: Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade
Date: Tue, 21 Nov 2017 12:01:27 -0500
Message-ID: <7442.1511283687@sss.pgh.pa.us> (raw)
In-Reply-To: <8F33D0C7-E12E-4996-990C-3CF0C5ED0437@filmlance.se>
References: <8F33D0C7-E12E-4996-990C-3CF0C5ED0437@filmlance.se>
"Henrik Cednert (Filmlance)" <henrik.cednert@filmlance.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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: tgl@sss.pgh.pa.us, henrik.cednert@filmlance.se, pgsql-performance@lists.postgresql.org
Subject: Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade
In-Reply-To: <7442.1511283687@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox