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 1q1FAV-0005YI-Gi for pgsql-general@arkaria.postgresql.org; Mon, 22 May 2023 23:42:23 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1q1FAU-0004GS-60 for pgsql-general@arkaria.postgresql.org; Mon, 22 May 2023 23:42:22 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1q1FAT-0004Eu-RZ for pgsql-general@lists.postgresql.org; Mon, 22 May 2023 23:42:21 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1q1FAN-001IDQ-9b for pgsql-general@lists.postgresql.org; Mon, 22 May 2023 23:42:20 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.15.2/8.15.2) with ESMTP id 34MNgERv774331; Mon, 22 May 2023 19:42:14 -0400 From: Tom Lane To: Jeff Ross cc: pgsql-general@lists.postgresql.org Subject: Re: 15 pg_upgrade with -j In-reply-to: <5fdaee55-81df-4be8-73c9-8e496bd02368@openvistas.net> References: <85a18793-627a-2a8b-1296-c965505694e6@openvistas.net> <13b3d746-a980-22d9-c88b-e74451536a11@aklaver.com> <5fdaee55-81df-4be8-73c9-8e496bd02368@openvistas.net> Comments: In-reply-to Jeff Ross message dated "Mon, 22 May 2023 17:29:39 -0600" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <774329.1684798934.1@sss.pgh.pa.us> Date: Mon, 22 May 2023 19:42:14 -0400 Message-ID: <774330.1684798934@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Jeff Ross writes: > On 5/22/23 5:24 PM, Adrian Klaver wrote: >> So is the 1400G mostly in one database in the cluster? > Yes, one big database with about 80 schemas and several other smaller > databases so -j should help, right? AFAICT from a quick look at the code, you won't get any meaningful parallelism unless you have several large DBs and/or several large tablespaces. 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. regards, tom lane