Re: Pg 16: will pg_dump & pg_restore be faster?

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: David Rowley <dgrowleyml(at)gmail(dot)com>
Cc: "Jonathan S(dot) Katz" <jkatz(at)postgresql(dot)org>, Ron <ronljohnsonjr(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org, Andres Freund <andres(at)anarazel(dot)de>
Subject: Re: Pg 16: will pg_dump & pg_restore be faster?
Date: 2023-05-31 11:00:10
Message-ID: ZHcouu3Eziqi83hM@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, May 30, 2023 at 10:28:58PM -0400, Bruce Momjian wrote:
> On Wed, May 31, 2023 at 02:18:25PM +1200, David Rowley wrote:
> > On Wed, 31 May 2023 at 14:11, Bruce Momjian <bruce(at)momjian(dot)us> wrote:
> > >
> > > On Wed, May 31, 2023 at 02:05:10PM +1200, David Rowley wrote:
> > > > "Relation extensions have been improved allowing faster bulk loading
> > > > of data using COPY. These improvements are more significant when
> > > > multiple processes are concurrently loading data into the same table."
> > >
> > > The release notes don't normally get into details on the magnitude of
> > > the improvement in various circumstances.
> >
> > Sorry, I meant the release announcement rather than the release notes here.
>
> Oh, yeah, that gets into more details, sure.
>
> There is also the major features list at the top of the release notes
> --- that needs adjustment based on release text I have updated recently,
> but I don't feel I control that list.

Oh, I now remember I added that and reworded it when I did, so I have
now adjusted it to match the new OUTER parallelism text.

--
Bruce Momjian <bruce(at)momjian(dot)us> https://momjian.us
EDB https://enterprisedb.com

Only you can decide what is important to you.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message hubert depesz lubaczewski 2023-05-31 13:17:26 Re: Is there a bug in psql? (SELECT ''';)
Previous Message Henrik Peinar (nodeSWAT.com) 2023-05-31 10:46:37 Help needed to understand query planner regression with incremental sort