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 1tuH6g-006zV1-4D for pgsql-hackers@arkaria.postgresql.org; Mon, 17 Mar 2025 20:30:42 +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 1tuH6e-001PnH-Ae for pgsql-hackers@arkaria.postgresql.org; Mon, 17 Mar 2025 20:30:40 +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 1tuH6d-001Pmr-QF for pgsql-hackers@lists.postgresql.org; Mon, 17 Mar 2025 20:30:40 +0000 Received: from mail-yb1-xb32.google.com ([2607:f8b0:4864:20::b32]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tuH6Z-003QxK-1q for pgsql-hackers@postgresql.org; Mon, 17 Mar 2025 20:30:39 +0000 Received: by mail-yb1-xb32.google.com with SMTP id 3f1490d57ef6-e634c42a296so3949766276.3 for ; Mon, 17 Mar 2025 13:30:36 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1742243435; x=1742848235; darn=postgresql.org; h=in-reply-to:content-transfer-encoding:content-disposition :mime-version:references:message-id:subject:cc:to:from:date:from:to :cc:subject:date:message-id:reply-to; bh=4i3jNl0bBisOgVlCeFuMmjFWubzQNNgiwEPPE3vSaIQ=; b=XoKf2dwxdydMctt+bDhGLON6rEcy9lRTCtElkzuzT8LG+uE1Bwg6Ly6i32w5df6A9q Bc7qiPmcydoRSz3Yzh3tx/sIZmdAgr8lbCRRmBp2yWX6joZ7liaRZxk/AhB1SSrAh8ye FqEog+nk7v3aJucJnXVMLWcBAUBiOq1D3oMu8lasyFgnGL0+dm7U0/znPvur8t5oOZZu MMZpqz5MIIotfExmPTIeOcu6YwCfp+fq8Ln5oGrV+9KvlIiYwgASkiNY965wBS76TqTr rseaFBQCuLi/LjeLYKI0WNT9HPgPZj5vgbMYLOmDcDckdfUGu1M+ZRXsH+qpQF0yxF26 /53w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1742243435; x=1742848235; h=in-reply-to:content-transfer-encoding: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=4i3jNl0bBisOgVlCeFuMmjFWubzQNNgiwEPPE3vSaIQ=; b=NFmwg7Sj5H7JgoSRYVcT5WdGRumcmTXvXkqaZkCP1yI06gmQ085DkfaAvZVUHFPHKj BzjcyDP9EJ6a2WmN7ne5i/F5l6S7160y0GZdAj9EsEleFAeN/36C6f0wfURSbeRKKpD5 mvwXK4V44r7lTgY2rCDYLySi82Wnofx0ZnGtqruiAVAMMGixEmVDONREjEhG08b3aP4V 3tZYfF4YF6xbpN+syd1gNaw4zCcafpmzKCLYoJBScGLUx/+KIOvuWktLATE0/YJHA2lm kYCSo4NveFN+XKpsL0lt0lBatYaGZ8gTD2URKO3tI/lfb+0ib3PfzWhiGUIvGV3ftWpi ELMQ== X-Forwarded-Encrypted: i=1; AJvYcCX9+xDUdN6wVCjfUCb6fpzY+8bMdPqPjrA/YAlIfsRrfCzna9Hb1aZ852LdcEl2chXVVPM/27ajKW4cjL4L@postgresql.org X-Gm-Message-State: AOJu0YwfEH9EWFLm/rmbZuz3umQn4WTpv6VsjKgb0kLyWfI/cSQLaQGl csNAP0vg+vqr/Dkm7KFaMSMWrv/qO0Z5N/f/gpb/F9O881Zqawsy X-Gm-Gg: ASbGnctcBLpNZAqmtDtjvxyAyWM9mt0NfKfZvfUnk2LoR+02WYVAQVCEMspaP4go7jH jD0MdD8/GhS/Rk/kEK6ZxU+9usCbPqMsHpxiCUIgyZQMg6FdNTnhhz0Q3DkbrWbT/Xvn/Nw5ifq RBpVEJsT030N0jVCl+52Ovr7Lw2+lldjRoMIVfoULS3kl38Ea2MeJXUvhC9/fxk8Iz5lUGzswdK rulkvx6yPwCxhKv0Nupf5Ep0TEof9HK/nr/PCRh3mnwx1Q15CytTr5358PEgnjMYGd9IyaLDHii YBBppTV0MYRHxo2sVIFg4O6LMRmeh9ExLIju7piDIA9M4UqOTbtHMM6cMznSmCXH15ZEUIfDUoR emDVW4jW79hx6ZfNBstjZMBRhE/KPDwHU1qo= X-Google-Smtp-Source: AGHT+IF6TP/vRIwZz1/pSUdLKnbz4OFREzh7+OLSW82vA/cQAZxnXQ/wcw/7uZhLh6F8Jqj1C5gafA== X-Received: by 2002:a05:6902:2184:b0:e60:93ee:d94 with SMTP id 3f1490d57ef6-e63f65bf38fmr16020995276.42.1742243434657; Mon, 17 Mar 2025 13:30:34 -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-e643f6e5eabsm215830276.16.2025.03.17.13.30.32 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 17 Mar 2025 13:30:33 -0700 (PDT) Date: Mon, 17 Mar 2025 15:30:31 -0500 From: Nathan Bossart To: Robert Haas Cc: Greg Sabino Mullane , pgsql-hackers@postgresql.org, bruce@momjian.us Subject: Re: optimize file transfer in pg_upgrade Message-ID: References: MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="/4djzC0ZDFNHPdW9" Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --/4djzC0ZDFNHPdW9 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit On Mon, Mar 17, 2025 at 04:04:45PM -0400, Robert Haas wrote: > On Mon, Mar 17, 2025 at 3:34 PM Nathan Bossart wrote: >> * Once committed, I should update one of my buildfarm animals to use >> PG_TEST_PG_UPGRADE_MODE=--swap. > > It would be better if we didn't need a separate buildfarm animal to > test this, because that means you won't get notified by local testing > OR by CI if you break this. Can we instead have one test that checks > this which is part of the normal test run? That's what I set out to do before I discovered PG_TEST_PG_UPGRADE_MODE. The commit message for b059a24 seemed to indicate that we don't want to automatically test all supported modes, but I agree that it would be nice to have some basic coverage for --swap on CI/buildfarm regardless of PG_TEST_PG_UPGRADE_MODE. How about we add a simple TAP test (attached), and I still plan on switching a buildfarm animal to --swap for more in-depth testing? -- nathan --/4djzC0ZDFNHPdW9 Content-Type: text/plain; charset=us-ascii Content-Disposition: attachment; filename="v6-0001-initdb-Add-no-sync-data-files.patch"