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 1tv5FI-00HAnE-OY for pgsql-hackers@arkaria.postgresql.org; Thu, 20 Mar 2025 02:02:57 +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 1tv5FF-00FJpn-L1 for pgsql-hackers@arkaria.postgresql.org; Thu, 20 Mar 2025 02:02:53 +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 1tv5FF-00FJlS-4B for pgsql-hackers@lists.postgresql.org; Thu, 20 Mar 2025 02:02:53 +0000 Received: from mail-yb1-xb2e.google.com ([2607:f8b0:4864:20::b2e]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tv5FA-0002UB-1F for pgsql-hackers@postgresql.org; Thu, 20 Mar 2025 02:02:50 +0000 Received: by mail-yb1-xb2e.google.com with SMTP id 3f1490d57ef6-e6405e4ab4dso1267409276.0 for ; Wed, 19 Mar 2025 19:02:47 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1742436166; x=1743040966; 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=8wbrhFHjSVMcA0TAvWlgpW7hp8qebFJszARD78le3SI=; b=fArAJUdyF5w7JujE8zEVrs1j24vJQp9ih5n6t5pg7myQmlNUEY/4EeX1XlqshjBcYH 9PUIWtx33StQdmqOXtv9PUHwRnVsFolJk0ZomotQR/bSXJ6rTCzlmv60ieZpD0WLgbvY F40xuY9skVf+jahbFis9E1aPv4HDDQV0p1Fm+39j8OPT35ykv1TUKWMe4Kuw6MyyVR4t /z0rwP4TorCmEu6gEHfV/AlpCncNZKoy4fka5pDRAcjNA0BVUrCFS/ef8+HjP+QKprad KHbZw0MvYNPOWSeZjD+q2cMZm6WwgH6Sk75DFksdW8HwlXQrL/eNUFexYWloXBxzBLAP +QSA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1742436166; x=1743040966; 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=8wbrhFHjSVMcA0TAvWlgpW7hp8qebFJszARD78le3SI=; b=hw5oPIo4Z0sQHqlxjEvXpxRp23GrP6fBDetooJK8e8uFOiB2q154J8J0ySZ79TBt/3 MSy6PZ8xYxf3SNgM5drkoDljL0yYupVhrzP38iuGmkWAlKZzAScfenoAhkQ9tqMSDzJO ML85rdzj+rhuAkXU+S31I2LRJ/8m48JmWFWU3eGCS2wP2EiBSUkFk524T5qY6C+N9pnm Ge8SzPfQXHBhuFDMHs3C6aJEQVFkuOFrRHK78GlZK49u3/p3i1/1cdV0hMQ0d3RghAqs muFgwIVxYz6Ks2vFmmlZTiFZNQglK6DQN7JKYQ60DQSVIe2SAZVmjlRGCV752zgkPI1A ETOw== X-Forwarded-Encrypted: i=1; AJvYcCVbKIplOWBxJ84jzR5EPvKCvYCZ/q1Rxq4mKTw3EbEGVUOoUGKtMwVfp9BNa4y7SyX1pJXg344+gB7RwVLz@postgresql.org X-Gm-Message-State: AOJu0YyKPswpWwXj09O5W/5iiajwqz3k2iCjrsMrxj/GT8yI2X6P84er Zrt68uVa15zS4HXPbmXWvCp6TQmTagZnEIAZTR9aM+FmbpgfZHHh X-Gm-Gg: ASbGncuuInQ6H0ZnWiV5X0WUafxVCz4rNjyB9v83MMjNcvXR0oGFzWNJ1a32/9y5uOe B8toW2ulUnjKN2VhLwKLkZ+zYCYmqaIeNio03gbvNCm5rFadxwXt+u4VLllaXBeR8rLAjXefnCf 1sJ0zc1Nxz3fyOjQk67PtO+GeBXLx9yTFwE6l9QUp+EB9cTTost1SdsRs/GGoIzZzO6cY+DkuWJ 2bhBzn7ttmwrzPQlo/TiuAMcZuzrZivT0OEzWAedXzMZb0xUU8lKN9F9Sz5lPDhpE+hrD6+7uRh NTvpZtyITyXoq/13JLFi032OcNR/gCi+0uGpZYdjmtCPGQZoyiNdYWwEXjpxXCF8M8ru1x1Tr9z 2dtKXDHyLP2bQptN94cja1DqI6k82C7GXEW0= X-Google-Smtp-Source: AGHT+IG9h0h0YTMjavanDsuQTY438DHTIB8sM7MjIUlNcHxscjXNs//pBlyhcaC9uQ+NrZ/2SlZ52g== X-Received: by 2002:a05:6902:cc7:b0:e5b:43dd:cf18 with SMTP id 3f1490d57ef6-e6690eef5bbmr2483131276.22.1742436165918; Wed, 19 Mar 2025 19:02:45 -0700 (PDT) Received: from nathan (162-195-168-172.lightspeed.stlsmo.sbcglobal.net. [162.195.168.172]) by smtp.gmail.com with ESMTPSA id 3f1490d57ef6-e63e57684aesm3310830276.54.2025.03.19.19.02.43 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 19 Mar 2025 19:02:44 -0700 (PDT) Date: Wed, 19 Mar 2025 21:02:42 -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="hXfPGy3/J5GGHYhH" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --hXfPGy3/J5GGHYhH Content-Type: text/plain; charset=us-ascii Content-Disposition: inline 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 --hXfPGy3/J5GGHYhH Content-Type: text/plain; charset=us-ascii Content-Disposition: attachment; filename="v8-0001-Add-test-for-pg_upgrade-file-transfer-modes.patch"