Re: optimize file transfer in pg_upgrade - Mailing list pgsql-hackers

From Andres Freund
Subject Re: optimize file transfer in pg_upgrade
Date
Msg-id tlkgkf3woe4ye2l4m4dnwui4wmqtajotozw5r3fhefyuv6hwrl@34xroqbvddpj
Whole thread Raw
In response to Re: optimize file transfer in pg_upgrade  (Nathan Bossart <nathandbossart@gmail.com>)
Responses Re: optimize file transfer in pg_upgrade
List pgsql-hackers
Hi,

On 2025-03-18 12:29:02 -0500, Nathan Bossart wrote:
> Here is a first sketch at a test that cycles through all the transfer modes
> and makes sure they succeed or fail with an error along the lines of "not
> supported on this platform."  Each test verifies that some very simple
> objects make it to the new version, which we could of course expand on.
> Would something like this suffice?

I'd add a few more complications:

- Create and test a relation that was rewritten, to ensure we test the
  relfilenode != oid case and one that isn't rewritten.

- Perhaps create a tablespace?

- Do we need a new old cluster for each of the modes? That seems like wasted
  time?  I guess it's required for --link...


Greetings,

Andres Freund



pgsql-hackers by date:

Previous
From: Nathan Bossart
Date:
Subject: Re: optimize file transfer in pg_upgrade
Next
From: Andres Freund
Date:
Subject: Re: md.c vs elog.c vs smgrreleaseall() in barrier