Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1q1WZl-0000d2-0Q for pgsql-general@arkaria.postgresql.org; Tue, 23 May 2023 18:17:37 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1q1WZi-0002UV-G4 for pgsql-general@arkaria.postgresql.org; Tue, 23 May 2023 18:17:34 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1q1WZi-0002UK-4I for pgsql-general@lists.postgresql.org; Tue, 23 May 2023 18:17:34 +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.94.2) (envelope-from ) id 1q1WZa-001hcq-Kd for pgsql-general@lists.postgresql.org; Tue, 23 May 2023 18:17:33 +0000 Received: by mail-yb1-xb32.google.com with SMTP id 3f1490d57ef6-ba94605bcd5so27276.2 for ; Tue, 23 May 2023 11:17:27 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1684865845; x=1687457845; h=content-transfer-encoding:in-reply-to:from:references:to :content-language:subject:user-agent:mime-version:date:message-id :from:to:cc:subject:date:message-id:reply-to; bh=6n6pN7jyDDvvd525c044BWpZb8cBd1YMbz1drvGKP1Q=; b=Qrq7MBd28qSNTRCa+Glwr+lrmCKUl8kZvtwBJ3GsPrjGNVGnxs37m5/6jirtAfNAAa O+6o2GcDslfrS78uyRcVgwGsFuGnLvTayn2NtQbZy72U8Q7aPyOJz0spy3eEMMxMwgrg Xn4Zxwd1YbdlCuLMUmcAjkANacc9tWpVraHSIAx3cHJVq+QusGmN8x07iNn7/iK5A3zb /J0BiH9iMGS4kOtX71LoI/CiYyWMYjAdx/qahbQThZpmMTEhh3YmzIj3gnOjgZTk52qE RBkTQ+fRzB9pJKr9fmbPWiRH4PcqhqEhSWq83PY1oeiQ02ZY0Jzxfl29n3bebsErbO+K dnwg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1684865845; x=1687457845; h=content-transfer-encoding:in-reply-to:from:references:to :content-language:subject:user-agent:mime-version:date:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=6n6pN7jyDDvvd525c044BWpZb8cBd1YMbz1drvGKP1Q=; b=Qnsjmvvcp4RnSBslypB5yyl5+j8hOfCGvdEoXQkHq5k2mr9oc3eAZ4mSPVN3u+rIwp uGo/8HyOK8qcCgZJYxFX+yUy5YYqsWY1OS59PZsmvxiXnInherSQB8lwQZyQnanjwzxN 5dBSeZ1JSEr34Mcol+/LLOy5Gr7Hdn28tX1kQq5EiySawg457ccK99aJC8O/1ex0t+66 MRaQoqhbd4KGdAN2IeRGKQeLHjzIex2dWOiwHHYdNPf6jhhd9/wEi/L0K0CmRbfgckfv PF9sMAytbdhYexrWZTnMliMLNwxA1abrIUZqgKxfZpDV7FJsqLbNeEyKK8crnRMXmeY8 eWLw== X-Gm-Message-State: AC+VfDwvSLv7t34ZnRNwI2io4U2RAmxFa9SR342mjgSX4TOiRaO5X4C9 wiAt2hL5mHHNFHwlD1CCXQyJzfon2Zk= X-Google-Smtp-Source: ACHHUZ5nrv63IgekS0cbYD6Ye/BufJzMVVPXMVOODKE2Syf7RpC66+SZMtvgTfYY33+oeZJfj8IHTA== X-Received: by 2002:a25:acd4:0:b0:ba8:7158:f0ac with SMTP id x20-20020a25acd4000000b00ba87158f0acmr16255078ybd.57.1684865844951; Tue, 23 May 2023 11:17:24 -0700 (PDT) Received: from ?IPV6:2600:1700:bd2c:b810:f43c:ec55:430:48c2? ([2600:1700:bd2c:b810:f43c:ec55:430:48c2]) by smtp.googlemail.com with ESMTPSA id q1-20020a258201000000b00b9949799ce3sm2199171ybk.32.2023.05.23.11.17.24 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Tue, 23 May 2023 11:17:24 -0700 (PDT) Message-ID: Date: Tue, 23 May 2023 13:17:24 -0500 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.10.0 Subject: Re: 15 pg_upgrade with -j Content-Language: en-US To: pgsql-general@lists.postgresql.org References: <85a18793-627a-2a8b-1296-c965505694e6@openvistas.net> <13b3d746-a980-22d9-c88b-e74451536a11@aklaver.com> <5fdaee55-81df-4be8-73c9-8e496bd02368@openvistas.net> <774330.1684798934@sss.pgh.pa.us> <20230523171929.5e3j56nbvaicexih@hjp.at> From: Ron In-Reply-To: <20230523171929.5e3j56nbvaicexih@hjp.at> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 5/23/23 12:19, Peter J. Holzer wrote: > On 2023-05-22 21:10:48 -0500, Ron wrote: >> On 5/22/23 18:42, Tom Lane wrote: >>> It looks like the assumption was that issuing link() >>> requests in parallel wouldn't help much but just swamp your disk >>> if they're all on the same filesystem. >>> Maybe that could use rethinking, not sure. >> It does need rethinking in the era of VMs and SANs. /var/lib/pgsql/15 is >> going to be on a different LUN from /var/lib/pgsql/9.6 > You can't hardlink between different file systems. We'd never hardlink.  Eliminates the ability to return to the old system if something goes wrong. -- Born in Arizona, moved to Babylonia.