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 1tv0xl-00FdJq-2E for pgsql-hackers@arkaria.postgresql.org; Wed, 19 Mar 2025 21:28:33 +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 1tv0xj-00C5UP-QM for pgsql-hackers@arkaria.postgresql.org; Wed, 19 Mar 2025 21:28:31 +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 1tv0xj-00C5UH-EV for pgsql-hackers@lists.postgresql.org; Wed, 19 Mar 2025 21:28:31 +0000 Received: from mail-yw1-x1131.google.com ([2607:f8b0:4864:20::1131]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tv0xg-0000Ot-2z for pgsql-hackers@postgresql.org; Wed, 19 Mar 2025 21:28:31 +0000 Received: by mail-yw1-x1131.google.com with SMTP id 00721157ae682-6f754678c29so1474807b3.0 for ; Wed, 19 Mar 2025 14:28:28 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1742419707; x=1743024507; 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=AOPF0hgBlEPpO/iq58+DbFh+Xm8iRe+xh052ymBuPwA=; b=RfA5eAQkou1lD+/cy4rowmTpx9WyF3o7N7Xz6kqG7xZrLSz4XFuXPriUGcwbnOTIXR XA2l4UEbC+cskMUJmGBfpOErBlkY+GDewTPAuieKveZc7pvM3I9DUynqSIabCJ7TLFON MXQcsBoieA5i5KaAgmWsQy5Vfr9DYqSEmsPxwJ3PfFSlsF4EdJWjUUv2670HibDTw8Vn p0dSwYTXpJOuDR6rML1Ng9Evi2BG3vD/F5X7lvOYriiTT3932i3iWiuILCSyuPwmHZWX 9Cite4N5L4SfMFCHLNZ15P7Bn8ZOgFjhFlTjBJXHU8jhJGn0HerB1Y7UTF6PrrDM7NQu A3Pw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1742419707; x=1743024507; 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=AOPF0hgBlEPpO/iq58+DbFh+Xm8iRe+xh052ymBuPwA=; b=v0khE03ZJVMw9Pdwd6PoAk0/9ZmeFEx/c2iGBGSz0dg06x3ZeieSxdp9O+Iij09akw 3bQahjFhX+GoD74Me6/dT4wj0VgEluBU1YYwq0sMz7fuN12c/4vkLKI4v3iRrlnMaSoq cXjn86e65Xeid6rIyvyC7s4OhhRp4zmWMfKjIckwlZQAyaLTlcgI7IMrs5czqlqYeg4t yxKbB+AS0w+OWcsbqxr0CFm5z3t/PInCsEplXMT+GmXFCrQjp4u3qnMr7rM/ZbTMBhR8 m7Hzq4lZOpM4wtlv9qXT2bDpBexi8OMi/oNXegsZcPdlDe59sj8CuN/WuFJfTtP2ceHV TTdA== X-Forwarded-Encrypted: i=1; AJvYcCXiGmmnMwMam8s6qs9HA0F7pBcAfx76jNZBD6a1Kjm/EcDP13miHQ1uEQSIhZVitCkfKuoqS1j6BNWZoVI1@postgresql.org X-Gm-Message-State: AOJu0YzzJgGB/xOBnYebzO+kBW4ZUSHJMHM1jtQCEbD2lsV+PQgbVQF+ gH31Y8/APrG6zmdWUP63FJu75jB7Sw/Nm9llbgb25OCtqO1bOrl2 X-Gm-Gg: ASbGncus7O3c5XWxVfSnjZ0ZPHD16hFzCuBJLKzFnekW1Nwxfs0KGszBmmjHUgC7uVK 5NDdw59Dfp5x0WTcIuSdUfqaG1Mmev5kNXTD/eKAnR8NjrBbpV3xcA0prJZgSP10KsNZeoBlW40 o8daWrgMJ0rmx/V3dMc2jXDhbinrGcXx+xr3/QqqShjslXTSagLc2qP1PLsy57NFMaYDyoTr1pC tjSuNDIKY4nMXbSu9Wz3rW/DN+jlBIGfq/5W9XTN/y7PfM85rOQKi+APTgCK+R5QjqSYSU6PYGX LM2EqxrDCNA+FUxdmrW7TqkVJo7sTVHDqVCL78WDmggM574UoveKc2uYW5fQsRkjvHMgncDrVOJ +QMCtQAtewY/tO8fm+7o78M/i7crg7fFK7DE= X-Google-Smtp-Source: AGHT+IHtac+szwIOzX0LCHpckr54vpCzr1hIB++9cYZ5S4gL9VIRjMmBoMzL7uGp3xwH7bCtlrQwfg== X-Received: by 2002:a05:690c:6ac8:b0:6f9:88ba:aa5d with SMTP id 00721157ae682-7009bf86272mr58848537b3.9.1742419706660; Wed, 19 Mar 2025 14:28:26 -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-6ff32a82b3csm32223377b3.64.2025.03.19.14.28.25 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 19 Mar 2025 14:28:26 -0700 (PDT) Date: Wed, 19 Mar 2025 16:28:23 -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: multipart/mixed; boundary="C5ohSC+cpjxht8ja" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --C5ohSC+cpjxht8ja Content-Type: text/plain; charset=us-ascii Content-Disposition: inline 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. -- nathan --C5ohSC+cpjxht8ja Content-Type: text/plain; charset=us-ascii Content-Disposition: attachment; filename="0001-Add-test-for-pg_upgrade-file-transfer-modes.patch"