Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1qtGBy-00Bduh-0p
	for pgsql-admin@arkaria.postgresql.org; Wed, 18 Oct 2023 23:43:10 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1qtGBv-00AEFm-NV
	for pgsql-admin@arkaria.postgresql.org; Wed, 18 Oct 2023 23:43:08 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <scott_ribe@elevated-dev.com>)
	id 1qtGBv-00AECy-CK
	for pgsql-admin@lists.postgresql.org; Wed, 18 Oct 2023 23:43:08 +0000
Received: from mailout.easymail.ca ([64.68.200.34])
	by makus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <scott_ribe@elevated-dev.com>)
	id 1qtGBs-001ANa-LI
	for pgsql-admin@lists.postgresql.org; Wed, 18 Oct 2023 23:43:06 +0000
Received: from localhost (localhost [127.0.0.1])
	by mailout.easymail.ca (Postfix) with ESMTP id 1C63D63E37;
	Wed, 18 Oct 2023 23:43:03 +0000 (UTC)
DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=elevated-dev.com;
	s=easymail; t=1697672583;
	bh=+JdMleqxba7vRGETe6nBh08XPrbSlZNS7JOAzQHX298=;
	h=Subject:From:In-Reply-To:Date:Cc:References:To:From;
	b=BN8qvZ70bGOnApn7WAA9c5ZBD3NC3T4vf1A5fbRUzitPtS1Fm1wK52doXhu6jqOvk
	 ZzRQbvtkvCQExsmm0Sgs5bITDC8uvtsvHQ0rkcPovXFSRmTxZfThlXNm9xQoNUfdHc
	 tvMEuMrMnV4MLflRZV0WGAGfha2HJbILO03gF0kawnNlWIgfWDt8M4VxloE+DN9AFy
	 2EKU8XsZ/fh651yOfoCNFikmP+s6vxUHv9HfYb6EqFdjc2g7UmW1m3k1/vjQmW6Aqn
	 IiuxJbDYHCN6Jvn0uECooY6ioRUlUZpBf8VH6tOvsSQ7Mg55pgX5O2JrYgpjMj0L6R
	 CdVQvGPcD4Z7Q==
X-Virus-Scanned: Debian amavisd-new at emo09-pco.easydns.vpn
Received: from mailout.easymail.ca ([127.0.0.1])
	by localhost (emo09-pco.easydns.vpn [127.0.0.1]) (amavisd-new, port 10024)
	with ESMTP id 9Eo1hv8qQaNj; Wed, 18 Oct 2023 23:43:02 +0000 (UTC)
Received: from smtpclient.apple (unknown [165.140.184.195])
	(using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits))
	(No client certificate requested)
	by mailout.easymail.ca (Postfix) with ESMTPSA id 4F79963E26;
	Wed, 18 Oct 2023 23:43:02 +0000 (UTC)
DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=elevated-dev.com;
	s=easymail; t=1697672582;
	bh=+JdMleqxba7vRGETe6nBh08XPrbSlZNS7JOAzQHX298=;
	h=Subject:From:In-Reply-To:Date:Cc:References:To:From;
	b=EUoKHMYIDrWCg6QrxeZlxxLuxAUXbKUi84W/e91X431vyE5Y7rUxlUx5ESRQ/1PDd
	 Iz4e4WuiyCWdxHpNokSC0aORyvdx3JXQWFbOlJOFBwyljL2G1EMBAYDWF33dPpGEKb
	 ASVy/HnxiO7nadBvnfQLuDxHqdytYyH20Di+8mIOe7A/zv2ZOgBW0GXKOKN6hQc5Sq
	 2Y0VzC7eanj51PukBhq2GE8yyAq+DiFsm2sKnK5LH6zHOMb6/kg981vRZxXw7gB8dV
	 arlMBpmqVjVyobeEO2vc9Q4vzY0P67+ErRI0tvKKm8VS6BbXoVEqtE7Pj3NALEALVb
	 Zlu4nDcwPDROA==
Content-Type: text/plain;
	charset=utf-8
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3774.100.2.1.4\))
Subject: Re: pg_dump -Z6 (the default) can be pretty slow
From: Scott Ribe <scott_ribe@elevated-dev.com>
In-Reply-To: <f290f176-4f75-473d-820a-a6257fa9f86f@gmail.com>
Date: Wed, 18 Oct 2023 17:42:51 -0600
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Transfer-Encoding: quoted-printable
Message-Id: <A271FB1A-55C7-4DB4-813A-EC54454EB573@elevated-dev.com>
References: <c2157b92-8802-41c9-a6b8-435d6d3793c0@gmail.com>
 <E9615CEC-CB92-4825-8BFC-0099F90107BD@elevated-dev.com>
 <f290f176-4f75-473d-820a-a6257fa9f86f@gmail.com>
To: Ron <ronljohnsonjr@gmail.com>
X-Mailer: Apple Mail (2.3774.100.2.1.4)
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Archived-At: 
 <https://www.postgresql.org/message-id/A271FB1A-55C7-4DB4-813A-EC54454EB573%40elevated-dev.com>
Precedence: bulk

> On Oct 18, 2023, at 5:21=E2=80=AFPM, Ron <ronljohnsonjr@gmail.com> =
wrote:
>=20
> It didn't occur to me to mention that I used it.  Do people really =
still not use -Fd?

I don't know--I guess it depends on context. Certainly for upgrades I =
don't know any reason not to.

> I'm still using 9.6, so that feature isn't available yet.  When I get =
the Pg 15 VMs stood up (Pg15 binaries are not available for RHEL 6), I'm =
definitely going to try that.

I thought of that mere seconds after posting my prior reply ;-)

Have you considered pg_upgrade?