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 1tvMRE-003tQY-2n for pgsql-hackers@arkaria.postgresql.org; Thu, 20 Mar 2025 20:24:24 +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 1tvMRC-008R1k-OM for pgsql-hackers@arkaria.postgresql.org; Thu, 20 Mar 2025 20:24:22 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tvMQD-008OEG-Ko for pgsql-hackers@lists.postgresql.org; Thu, 20 Mar 2025 20:23:22 +0000 Received: from mail-yb1-xb33.google.com ([2607:f8b0:4864:20::b33]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tvMQ9-000C6u-1t for pgsql-hackers@postgresql.org; Thu, 20 Mar 2025 20:23:20 +0000 Received: by mail-yb1-xb33.google.com with SMTP id 3f1490d57ef6-e63504bedd0so922489276.0 for ; Thu, 20 Mar 2025 13:23:17 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1742502196; x=1743106996; 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=/I60ckyNmfQrH0XrgBODnfwnJN/9+mIGYApgx6KsZK0=; b=Jcy3oQF7Ex6zgrMDzKfsHLOwJzlaOufue3C+TyZGjQ2OmJ3LzYrHKzmU8TxWDX5kz+ UT9wWFsDKme0L4QTIpb9qB9QCILLS6ifJMobi0tfnpFHEVz8irEoB8gcBdj/vFvVrTyb rMTnpM4jtXZaQC4sjWkN7PlweicIq89Ay2K1dU9/IzsT2BviKalzXSz2RtKW3NTMA5dd hU5JHn9qWjS7MdXQAPbNUR3dpweUIpAKj8b5iyM4py0SUN/9h1tqEUYq3Z3L0NU9ZNYo o94DB9sksfRp3fc9hAVk3Qbz6a7Fl+A86kr4SQ54HF1OZlIaqzmyFFY20UlNskvT2kl/ bb/Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1742502197; x=1743106997; 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=/I60ckyNmfQrH0XrgBODnfwnJN/9+mIGYApgx6KsZK0=; b=jZ7MTyU+307SzvHyzQvZXoOrNmbKAu484JwjhRhNmxDqmqXSo9NNNix5stl1uZzkS7 sm7HMZ1eWYWfphLhetWBZzYbNGsKe6yJJe/tJKt/sI46Assk/ixVBURFWdTEms4ehW8C dkQkCenIccyO5fd4kZz42XPcN5QHnWNZ8ib7ET8WPqd2qaXgakoRM+mwB2V1yzV4MzG3 pbhXmBukKqjB7ObxxZDW5VCIZOh8jwx+szV8SJHW1giwcfdV0JYP9/MskwRQAJQVPuMI jfxPQjEL/YvWYmUjXPakPiwC+8y3yFFdYooN/Ns8N35VRlleh9i6dFUFBhhfYoMj5S8a ePfA== X-Forwarded-Encrypted: i=1; AJvYcCW2QBFFJxrle+KfS80ds2zNer0ABStZXN4rhoVno9e4E6Bzk9sve3wILS5sgxJkKoj8GgOH7UTIbBI9NF+V@postgresql.org X-Gm-Message-State: AOJu0Yz3maIDQXyzOGJ2psBYqPTUdDLvSEzw3BRDp3578XfTSiORNQZ4 7zumzA8a/T0Y4aq8CG0HIi29u7j3HuDUTQ6ZulTk9qLJOQoCiE6+ X-Gm-Gg: ASbGnctu/auWZpIVvIR7/pFjNoiAGqu7g3xAgfIE/brw4bh5XKxXDJ3jd5g10ypXIdj RVDE3cbLUr/xtn/vida1avXMsuEt2yeChX1UnP+hAoQFV3HR4uRzgOOgR4OQmL8qdOkNJeWi1vZ 4sWdEVzsvo+g065sTF/CFszf40UaYuyBv6QMYtWb4N5LyruW7kcEfazhhgLwqWfgzSNDZserzSR HFFYTJx8TqsriJrFYryhpAYNff5jCcGD1dIJNomAmmaZc74i6p+rmhVHiquTnDbBJRtJGfXEoeo E002/pHfCHdOtrtcLPj3wMbvq3NrvUaBgf7Nd/SJfJnTLM1gDdc8v3FRK1BMbTtVMf04iDE1sJE YuSsWc8ZXm+dIVmy/lBoxLVvcPhQYKo0/2FI= X-Google-Smtp-Source: AGHT+IEb10jg22A/RjdJ33Ejg70cx+2qJCV0XEbjXsY44ckKILkznRowoU2Qx7XIvk/o/mTLG/t9lw== X-Received: by 2002:a05:6902:1693:b0:e5d:bcc5:c33a with SMTP id 3f1490d57ef6-e66a4fa5aaamr785560276.43.1742502196180; Thu, 20 Mar 2025 13:23:16 -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-e66a442ffa1sm63285276.44.2025.03.20.13.23.14 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 20 Mar 2025 13:23:15 -0700 (PDT) Date: Thu, 20 Mar 2025 15:23:13 -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="pLR3ODfl/bBGLi7m" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --pLR3ODfl/bBGLi7m Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Thu, Mar 20, 2025 at 11:11:46AM -0500, Nathan Bossart wrote: > As promised, I've committed just 0001 for now. I'll watch closely for any > issues in the buildfarm. Seeing none, here's is a rebased patch set without 0001. The only changes are some fleshed-out comments and commit messages. I'm still aiming to commit this sometime early next week. -- nathan --pLR3ODfl/bBGLi7m Content-Type: text/plain; charset=us-ascii Content-Disposition: attachment; filename="v9-0001-initdb-Add-no-sync-data-files.patch"