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 1tuvOE-00EEai-Hq for pgsql-hackers@arkaria.postgresql.org; Wed, 19 Mar 2025 15:31:30 +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 1tuvOD-006eX6-9E for pgsql-hackers@arkaria.postgresql.org; Wed, 19 Mar 2025 15:31:29 +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 1tuvOC-006eWM-V5 for pgsql-hackers@lists.postgresql.org; Wed, 19 Mar 2025 15:31:28 +0000 Received: from mail-yw1-x1133.google.com ([2607:f8b0:4864:20::1133]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tuvO9-003me6-1n for pgsql-hackers@postgresql.org; Wed, 19 Mar 2025 15:31:28 +0000 Received: by mail-yw1-x1133.google.com with SMTP id 00721157ae682-6ff1814102aso7293977b3.1 for ; Wed, 19 Mar 2025 08:31:26 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1742398285; x=1743003085; 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=CSb7qtC01l55xDJs1gMkm6BGsvdKWXUVcFU9Ui+vPec=; b=czAVvWAoswkI5KlAk8K44/E3GRn5Eift8MpT+S48Ilm2I7B0V56Jq/GNCvlJL1DmAm BKOMM1GeTj54rE/jjMvLYM3Yc8MkOP92SYsz/BPtvc18jMj2hXVOUs+BOJLCYpvDncwy aP+Vz13caZ06cINK7RIPH50fcA1VxULHw3Rg0GXgAgxEOVGJbj+D50r78N0riHxtnHwD RLW/EpeE89FNIDh65gFL3cnsBz9bkvU13YjKTNZ556nbTY50+pVU4Hjm5tB7St+mh3RO ASKph/40bn0WWqnFDOCLXgIc50JHPPaVNSuxv6c6DrTnRuETi99hEKOCAHHgV2eD2/Rm 3mbQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1742398285; x=1743003085; 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=CSb7qtC01l55xDJs1gMkm6BGsvdKWXUVcFU9Ui+vPec=; b=nQ62/LfTXB1xKJdOsHx4HH5oNjhzhItEYu2EryrurfyEV5I+tI9Uiumvz7u75S9VMq zIN9CRjQpEZP6foXzT5Fzr5O0wFrjTNhWQj45NSs1HbddrP0Xz6i4Q8FHkxXhZDHVzG5 +KgAa9a4N9+sWkoyLQPWJEzTFRV+dE4GUQYuulGQd4rjyt+esIVfU2J+yQHC7v9bPJ7f ZI+54RceDcPsksozb07uDvwr1mgynrzxkzxp8mM3hE9tuCPPYSwb9eP4K0UoPW2Itu4q AbsX/UpSwknOpVurNmDaef3bRJo3qQ3fZhTjnLBsxVhir+deY1CeN9A2nIkzvjBf8gWY mIlA== X-Forwarded-Encrypted: i=1; AJvYcCVF5ZP5n4WK6l7bsTH7uLfC+xQEp5eyP6DUBaoi9ZUqStyynr5PrtmqdLI8+9cgaM3tmPJSzw9S53R1lfT3@postgresql.org X-Gm-Message-State: AOJu0YyJ6/aWHXbsi8opHr74aaD2FEebz5QLhZe7Eh6rDfPEWqNTc6qv ngyftuCpEDtd+4d2tNXNps5Oji5GyHmPbc1nY85nPf4dwnddSXHi X-Gm-Gg: ASbGncux4rpxdsOXZtMPFi5rDXNYydhIlo0r1vpK7QFCflAQKN7EeW7wVwrNDMNew6O +yxkafyftWkwyyYOAzOVmKnNsf8UDvbyx7R2CrWsl65MJccP2/btnrODeOoPtfNd75w1X7tu9gT oyaZXVid+e6fmjS5rBqgfqLxcByzJ4yYUjRtQ0f5BgSjTivQVS8x2QGF5sgqysnYDOD9bMPsu/6 33cnXEgJnZfqv9PW37Km2NtZkhpQCIB63ef1KCMux37pTOWnDzcI4fW3lc6p/biAYPEvodHqR4N oL3o5AQmq7NNdWKNXzFonjas3ZmVD664ZCB6NHyd1TL+HolUFXoTzDtlgQwwjjzUtQsIQRwsIkV aMaiY6j615qoXmxcdqKlmFo2/h7FIZBWlKW1lk61lhJeiLg== X-Google-Smtp-Source: AGHT+IH/IIIzpDCylmkr74x4zkRPDzU+yDgRY8xP2t7fhtNmPSmydK8x57DZTGFJ/0XBISJkFFcb1g== X-Received: by 2002:a05:690c:6c89:b0:6f9:e4e1:a86 with SMTP id 00721157ae682-6fff852e312mr131707137b3.16.1742398284932; Wed, 19 Mar 2025 08:31:24 -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-6ff32d0036esm31115167b3.124.2025.03.19.08.31.23 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 19 Mar 2025 08:31:24 -0700 (PDT) Date: Wed, 19 Mar 2025 10:31:22 -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: <17820.1742306681@sss.pgh.pa.us> <7rhxl5nl5cuenm4kzprjhaojo74m2teuwzjffcrdi6bxx6b2wn@orb5h3mteh2y> 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 Tue, Mar 18, 2025 at 09:14:22PM -0500, Nathan Bossart wrote: > And here is a new version of the full patch set. I'm currently planning to commit this sometime early-ish next week. One notable loose end is the lack of a pg_upgrade test with a non-default tablespace, but that is an existing problem that IMHO is best handled separately (since we can only test it in cross-version upgrades). -- nathan