Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Gunther <raj(at)gusw(dot)net>, pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade
Date: 2017-12-07 17:31:35
Message-ID: 1512667895.2915.13.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Gunther wrote:
> Something is wrong with the dump thing. And no, it's not SSL or whatever,
> I am doing it on a local system with local connections. Version 9.5 something.

That's a lot of useful information.

Try to profile where the time is spent, using "perf" or similar.

Do you connect via the network, TCP localhost or UNIX sockets?
The last option should be the fastest.

Yours,
Laurenz Albe

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Claudio Freire 2017-12-07 17:56:37 Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade
Previous Message Tom Lane 2017-12-07 16:38:30 Re: [PERFORM] Slow execution of SET ROLE, SET search_path and RESET ROLE