From: Scott Ribe <scott_ribe@elevated-dev.com>
To: Ron <ronljohnsonjr@gmail.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Re: pg_dump -Z6 (the default) can be pretty slow
Date: Wed, 18 Oct 2023 17:42:51 -0600
Message-ID: <A271FB1A-55C7-4DB4-813A-EC54454EB573@elevated-dev.com> (raw)
In-Reply-To: <f290f176-4f75-473d-820a-a6257fa9f86f@gmail.com>
References: <c2157b92-8802-41c9-a6b8-435d6d3793c0@gmail.com>
<E9615CEC-CB92-4825-8BFC-0099F90107BD@elevated-dev.com>
<f290f176-4f75-473d-820a-a6257fa9f86f@gmail.com>
> On Oct 18, 2023, at 5:21 PM, Ron <ronljohnsonjr@gmail.com> wrote:
>
> 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?
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-admin@postgresql.org
Cc: scott_ribe@elevated-dev.com, ronljohnsonjr@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: pg_dump -Z6 (the default) can be pretty slow
In-Reply-To: <A271FB1A-55C7-4DB4-813A-EC54454EB573@elevated-dev.com>
* 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