Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade - Mailing list pgsql-performance

From Henrik Cednert (Filmlance)
Subject Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade
Date
Msg-id 2D863ADA-134E-414B-82DD-88E53D621697@filmlance.se
Whole thread Raw
In response to Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
Hello

Running it with format "directory" produced something I cannot import form the host application. So I aborted that.

Running it now and recording with Instruments. Guess I'll have to leave it cooking for the full procedure but I've added an initial one to pastebin.

I'm not sure if I can attach screenshots here. Trying, screenshot from instruments after running for a few mins. 




--
Henrik Cednert
cto | compositor

Filmlance International
mobile [ + 46 (0)704 71 89 54 ]
skype  [ cednert ]

On 21 Nov 2017, at 19:46, Tom Lane <tgl@sss.pgh.pa.us> wrote:

Robert Haas <robertmhaas@gmail.com> writes:
On Tue, Nov 21, 2017 at 12:01 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
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.

macOS's "sample" is pretty easy to use and produces text format output
that is easy to email.

Ah, good idea.  But note that only traces one process, so you'd need to
first determine whether it's pg_dump or the backend that's eating most
of the CPU.  Or sample both of them.

regards, tom lane

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade
Next
From: "Henrik Cednert (Filmlance)"
Date:
Subject: Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade