Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tvIUt-003DP1-MW for pgsql-hackers@arkaria.postgresql.org; Thu, 20 Mar 2025 16:11:55 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tvIUs-004AN8-0Y for pgsql-hackers@arkaria.postgresql.org; Thu, 20 Mar 2025 16:11:54 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tvIUr-004AMP-NR for pgsql-hackers@lists.postgresql.org; Thu, 20 Mar 2025 16:11:53 +0000 Received: from mail-yb1-xb33.google.com ([2607:f8b0:4864:20::b33]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tvIUp-000AO9-0d for pgsql-hackers@postgresql.org; Thu, 20 Mar 2025 16:11:53 +0000 Received: by mail-yb1-xb33.google.com with SMTP id 3f1490d57ef6-e53ef7462b6so892518276.3 for ; Thu, 20 Mar 2025 09:11:51 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1742487110; x=1743091910; darn=postgresql.org; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:from:to:cc:subject:date:message-id:reply-to; bh=t4ptEnHjcG95cjb6ct4hqUgTtElYY6a8bq+LxWhumco=; b=Od/SLVuOwIbHv5ayri5Aw38a4UQbmuP8ASeos6X9O/a7Saw+ePDBKssR7nkaesNWaN hH7wpVBORD2RSVUNGLrtl5zQSxqxTIYam3oI9G4aTH0KQqizMNddQEBoAxrz/77a0iyz 3e+xw+vjz+4qeveMjkd9ytd7yupUI8wB62At1n93k1YmrnP8i0prEggiwmQznu2JIYR4 8xZ6RnkPiVri9bG0VP2vrXvxfFmdm+KbXBlM22glw898LuL/VfVNxRJuXY16j1sk7Tnb RjSNFWR7mZiOFJKbWcqqQC7C+os/a/OyQovOTV7HegBiwpoindOHHtf1gUFETd+oznZf DlyQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1742487110; x=1743091910; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=t4ptEnHjcG95cjb6ct4hqUgTtElYY6a8bq+LxWhumco=; b=viaGAbGPIfB4YgXJ+Er0MBpizAazY/JKUD8gJlYoNFUuxeWT8/X3AVrk8JA4x/qflg EVzceO4JpS6vnjOsUbD0GfZwclvzLjgkJwcjEtbw2Mk5Y5gqO4oeuWTOOHxNK65XMEDO Xhpxd5jHgWEl20SbBH/xjCeXcmLdDneAvIiwSLnYEhdqJs4Wgn0wTBiQPEOxVdKqs7ZH VLlmg1uITAjHWPiDoXAOHQeMCS8AC4cNa6lUrIjWJDsaRhjjreXz5qXBpfof85ATskwi PLqwOmlMQhZFwocW6QD5Tm67Ax4pelze+Us5HVKq3SeK9Wo63BO74KKTAuEz+dB4iSpF zbBQ== X-Forwarded-Encrypted: i=1; AJvYcCWURGfk8MAYUtBsHrfDc4um1cEOSPEOm3t33AzNQ/T3fs/v/1aTe9faLBkKT/fhMAfc3QvJxgG3MQNjsH12@postgresql.org X-Gm-Message-State: AOJu0YzAYZOxaiEa1fCP58usalGBEjkYSIT0lnoXCIiOzBM1CsoHvSbB ICqsTzRGR8LnKqXx34BJRygXYSlLwb1DVxSRIaFquRpMbL5GrtTE X-Gm-Gg: ASbGncsuDvViep+fMOidiTTVp2AbkX3xwzPvd7Ookw8F+h4jfr+F52yKG+/VU3J3dQe LJRCNQy2VC6aorqG6T2WoQnVWYU+7j476zJHBKYkiQ4dgF2sKHuENDz5IRoGDz2uvSJ/x5aouGT gR4n4F2AsEMKhBtj4kokPzHxA6WqBVoxoXJhwxlZc05X5puCJdrDfAy0H+2jzhDZuyM7G2vFOcZ fMq2JR+nb1I/K2oaA3bJEQQuAKDB3UOZQvxoE76Y7Ia86NmiruyP7rN9pMRYALtcOH27Wy7Y79U Q09jV0dZCflJmjGu2YVioFjEEN3sVKvnvM39i6OemfKaIizDl/1Z5mBNVsqWCcTJCPj3N5mUuhN oDqdyAHpdIkAeKPNMCZHOFM5nDOGafqY59uA= X-Google-Smtp-Source: AGHT+IGq6tgGQs83XJDCaC+RgSrL7Mgiau1aSpkX3083CTwFw1ETNT2kLbIZtP+0M1nEYIe1hfXVzg== X-Received: by 2002:a05:690c:368e:b0:6fb:1f78:d9ee with SMTP id 00721157ae682-7009bf7eff8mr105026367b3.15.1742487109483; Thu, 20 Mar 2025 09:11:49 -0700 (PDT) Received: from nathan (162-195-168-172.lightspeed.stlsmo.sbcglobal.net. [162.195.168.172]) by smtp.gmail.com with ESMTPSA id 00721157ae682-6ff32c7a735sm36073457b3.81.2025.03.20.09.11.48 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 20 Mar 2025 09:11:49 -0700 (PDT) Date: Thu, 20 Mar 2025 11:11:46 -0500 From: Nathan Bossart To: Andres Freund Cc: Tom Lane , Robert Haas , Greg Sabino Mullane , pgsql-hackers@postgresql.org, bruce@momjian.us Subject: Re: optimize file transfer in pg_upgrade Message-ID: References: <7rhxl5nl5cuenm4kzprjhaojo74m2teuwzjffcrdi6bxx6b2wn@orb5h3mteh2y> <712605.1742401713@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, Mar 19, 2025 at 09:02:42PM -0500, Nathan Bossart wrote: > 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... As promised, I've committed just 0001 for now. I'll watch closely for any issues in the buildfarm. -- nathan