Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtp (Exim 4.84_2)
	(envelope-from <pgsql-performance-owner+archive@lists.postgresql.org>)
	id 1eN01a-0000Dd-Ui
	for pgsql-performance@arkaria.postgresql.org; Thu, 07 Dec 2017 17:31:55 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.84_2)
	(envelope-from <pgsql-performance-owner+archive@lists.postgresql.org>)
	id 1eN01Z-0000Ej-RC
	for pgsql-performance@arkaria.postgresql.org; Thu, 07 Dec 2017 17:31:53 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.84_2)
	(envelope-from <laurenz.albe@cybertec.at>)
	id 1eN01Z-0000Ea-Ki
	for pgsql-performance@lists.postgresql.org; Thu, 07 Dec 2017 17:31:53 +0000
Received: from mx2.mailbox.org ([80.241.60.215])
	by magus.postgresql.org with esmtps (TLS1.2:RSA_AES_256_CBC_SHA1:256)
	(Exim 4.89)
	(envelope-from <laurenz.albe@cybertec.at>)
	id 1eN01W-0000gW-Ju
	for pgsql-performance@lists.postgresql.org; Thu, 07 Dec 2017 17:31:52 +0000
Received: from smtp1.mailbox.org (smtp1.mailbox.org [80.241.60.240])
	(using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits))
	(No client certificate requested)
	by mx2.mailbox.org (Postfix) with ESMTPS id 6B8A14C897;
	Thu,  7 Dec 2017 18:31:48 +0100 (CET)
X-Virus-Scanned: amavisd-new at heinlein-support.de
Received: from smtp1.mailbox.org ([80.241.60.240])
	by spamfilter02.heinlein-hosting.de (spamfilter02.heinlein-hosting.de
 [80.241.56.116]) (amavisd-new, port 10030)
	with ESMTP id osHEwcGT0HfO; Thu,  7 Dec 2017 18:31:47 +0100 (CET)
Message-ID: <1512667895.2915.13.camel@cybertec.at>
Subject: Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Gunther <raj@gusw.net>, pgsql-performance@lists.postgresql.org
Date: Thu, 07 Dec 2017 18:31:35 +0100
In-Reply-To: <fbcba138-d467-440a-53c5-dae03e926170@gusw.net>
References: <8F33D0C7-E12E-4996-990C-3CF0C5ED0437@filmlance.se>
	 <0bc6cc72-7d7d-b157-4824-7a6ea2985a60@hipay.com>
	 <A456F355-B91C-42CD-AFA1-6572CA2C1546@filmlance.se>
	 <fbcba138-d467-440a-53c5-dae03e926170@gusw.net>
Organization: Cybertec
Content-Type: text/plain; charset="UTF-8"
Mime-Version: 1.0
Content-Transfer-Encoding: 7bit
List-Id: <pgsql-performance.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-performance@lists.postgresql.org>
List-Owner: <mailto:pgsql-performance-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-performance>
Precedence: bulk

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