Re: pg_dump -Z6 (the default) can be pretty slow

From: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
To: Ron <ronljohnsonjr(at)gmail(dot)com>
Cc: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: pg_dump -Z6 (the default) can be pretty slow
Date: 2023-10-18 23:42:51
Message-ID: A271FB1A-55C7-4DB4-813A-EC54454EB573@elevated-dev.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

> On Oct 18, 2023, at 5:21 PM, Ron <ronljohnsonjr(at)gmail(dot)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?

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ron 2023-10-19 00:00:31 Re: pg_dump -Z6 (the default) can be pretty slow
Previous Message Ron 2023-10-18 23:21:22 Re: pg_dump -Z6 (the default) can be pretty slow