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 1u9TBj-002AVF-Ba for pgsql-hackers@arkaria.postgresql.org; Mon, 28 Apr 2025 18:26:43 +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 1u9TBh-002oNr-AO for pgsql-hackers@arkaria.postgresql.org; Mon, 28 Apr 2025 18:26:42 +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 1u9TBh-002oNj-0n for pgsql-hackers@lists.postgresql.org; Mon, 28 Apr 2025 18:26:42 +0000 Received: from mail-io1-xd36.google.com ([2607:f8b0:4864:20::d36]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1u9TBf-00039p-23 for pgsql-hackers@postgresql.org; Mon, 28 Apr 2025 18:26:41 +0000 Received: by mail-io1-xd36.google.com with SMTP id ca18e2360f4ac-85df99da233so584176239f.3 for ; Mon, 28 Apr 2025 11:26:39 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1745864796; x=1746469596; 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=5DJfnpxwr4ZSadCQl+RzzkTLZ89/xzUoNnXvVEUeIbQ=; b=EOfb70K4TvWurYAG69DB0dzE4WH6mvNSFKZRF7EBv2VbLt3VtsPJVqTeRX3EJLR2vi mBCeiOOmI+Ud3wwo+siS2DBoCYnExY7TUA4Y8TBG1iAXQkvDogqaJP6/r7H4bevs8NN0 8iEXCxciCrh1yoJ/Q+JPUCtt1sM6nKd3ke4QgwIYybCEIDttHARHdgqDRZY9K+eRjdai CZosC8689XrwWlkUumvxAsFEcVvhRwPXS0GLk1TX3ODbgjQR+aFkTqVaKkJElaNyR6Ho H/V9MV+Oo169+fEbo3PgawUMkN8ot6G3IDH4px1kA+hJomeYoPryg/uJcgyirVFISSku Ft9w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1745864796; x=1746469596; 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=5DJfnpxwr4ZSadCQl+RzzkTLZ89/xzUoNnXvVEUeIbQ=; b=xJSHRPGT2VGruqZE98MjpSbYttTS9GoN9/LUdSBj4133w2s4DkQGAh2nHNjdQAL2b9 ZpZkr7/dbtoFth5QZ3ulh6thZK4g1l7m3mgDwtD3HnOoB+EbomY2R4aIDLlSzDHk8Jx/ CfyK2rkVj4TV6ngPIXIt9kRwkwv4XsUrfNMMVePl7hZM0MKXCEdAW17iaim2I+GpZzC9 QEpCvn7lju1KIKwQx7ThMOAAsn8TC+sHd4CGFTTQd6Tt3pWeFlUltBSpr5YeYRM0pbGZ /W3vsAiKK1GTYZDGwPdMB/rjZWuTF6Q1D6kzzz3z0jKG1WcXzPE5RQwQNFPAKZZNQ6PI O26w== X-Forwarded-Encrypted: i=1; AJvYcCWbMEPYPjAB1UKY9UiVBlJH0bLomqioNBG9N6y2mOPZoA/HK07nRn1p8N3nqpFhNpAsvWBqpcLMOVXv40yR@postgresql.org X-Gm-Message-State: AOJu0YydMSi6nnc5MVsvtV/Com7WOmdj+PwyYsQQK3lR9TEfWiEJT09X T6AHpGkTR8Ys4QttuC3/5leGcAlB5jdS5R08iASRSDjNyd84g7pl X-Gm-Gg: ASbGncuw4UXv+lAN39ZCXONOdWov9tcLydfq8Hf3fep551rwjz4yM7RczUokbbpXCwk HvKsiR89Tw14bj23D97qiAdH2wdYEQrtd7ZgtnmeiGQ5GTyk0AeQbsdhgT1WA1M6flPeMHriGLF fpTCupDY/YIe+ZaEs4JIEU/ZvrXaTh+LLT/KKjgJeHjpCFC8fWtWCBzedbmCoCpYCmP0AfX1RcH FBtDrpKU+jv+9GmKtjeNHBe0tf1J+aCanBkrMWta22/HRqh6IqBHd4GaqI4TL33bb0IQtWiVsVX obfCR+as8sQGLWkVTw9zGaDyXd+/s/EZjbqLfEpWFBPnnU9toXMb2ql49vHw/5VA08rk95h0bXl ciCLl8RaaTgNP0WiWBk24r+EMTiTvJPk= X-Google-Smtp-Source: AGHT+IGp9L3gbm2YEjrsezQGA+Qf/EXa74IqyNeLDxgmCqn+Wvrrxs2Ttm/A9QLqDrwj13JJcfRCsA== X-Received: by 2002:a05:6602:27c6:b0:861:d8ca:3587 with SMTP id ca18e2360f4ac-86467ad5258mr1216002839f.4.1745864796451; Mon, 28 Apr 2025 11:26:36 -0700 (PDT) Received: from nathan (162-195-168-172.lightspeed.stlsmo.sbcglobal.net. [162.195.168.172]) by smtp.gmail.com with ESMTPSA id 8926c6da1cb9f-4f824bc4494sm2303487173.145.2025.04.28.11.26.35 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 28 Apr 2025 11:26:36 -0700 (PDT) Date: Mon, 28 Apr 2025 13:26:34 -0500 From: Nathan Bossart To: Alexander Lakhin Cc: Tom Lane , Robert Haas , Andres Freund , Greg Sabino Mullane , pgsql-hackers@postgresql.org, bruce@momjian.us Subject: Re: optimize file transfer in pg_upgrade Message-ID: References: <712605.1742401713@sss.pgh.pa.us> <7161562f-d00d-41a6-bd8a-d15684d3eaf2@gmail.com> <67e69649-30ff-4b72-9427-7978010701af@gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <67e69649-30ff-4b72-9427-7978010701af@gmail.com> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, Apr 28, 2025 at 09:00:01PM +0300, Alexander Lakhin wrote: > Thank you for the references! Unfortunately I still can't see where the > lack of upgrade log files is discussed. That was briefly discussed here: https://postgr.es/m/644cf995-e3a5-4f69-9398-7db500e2673d%40dunslane.net One other potential problem with this test is that we reuse the directory names for each transfer mode. That seems easy enough to fix. -- nathan