Re: optimize file transfer in pg_upgrade

From: Nathan Bossart <nathandbossart(at)gmail(dot)com>
To: Andres Freund <andres(at)anarazel(dot)de>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Robert Haas <robertmhaas(at)gmail(dot)com>, Greg Sabino Mullane <htamfids(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org, bruce(at)momjian(dot)us
Subject: Re: optimize file transfer in pg_upgrade
Date: 2025-03-20 02:02:42
Message-ID: Z9t3QsiVz2jHw76A@nathan
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, Mar 19, 2025 at 04:28:23PM -0500, Nathan Bossart wrote:
> On Wed, Mar 19, 2025 at 02:32:01PM -0500, Nathan Bossart wrote:
>> In addition to testing with in-place tablespaces, we might also want to
>> teach the transfer modes test to do cross-version testing when possible.
>> In that case, we can test normal (non-in-place) tablespaces. However, that
>> would be limited to the buildfarm.
>
> Actually, this one was pretty easy to do.

And here is yet another new version of the full patch set. I'm planning to
commit 0001 (the new pg_upgrade transfer mode test) tomorrow so that I can
deal with any buildfarm indigestion before committing swap mode. I did run
the test locally for upgrades from v9.6, v13, and v17, but who knows what
unique configurations I've failed to anticipate...

--
nathan

Attachment Content-Type Size
v8-0001-Add-test-for-pg_upgrade-file-transfer-modes.patch text/plain 7.2 KB
v8-0002-initdb-Add-no-sync-data-files.patch text/plain 13.3 KB
v8-0003-pg_dump-Add-sequence-data.patch text/plain 4.9 KB
v8-0004-pg_upgrade-Add-swap-for-faster-file-transfer.patch text/plain 31.2 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message David G. Johnston 2025-03-20 02:15:43 Re: split func.sgml to separated individual sgml files
Previous Message Sutou Kouhei 2025-03-20 01:24:55 Re: Make COPY format extendable: Extract COPY TO format implementations