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 1q1FBu-0005bR-OJ for pgsql-general@arkaria.postgresql.org; Mon, 22 May 2023 23:43:50 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1q1FBt-00009O-J3 for pgsql-general@arkaria.postgresql.org; Mon, 22 May 2023 23:43:49 +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 1q1FBs-00009F-K8 for pgsql-general@lists.postgresql.org; Mon, 22 May 2023 23:43:49 +0000 Received: from out2-smtp.messagingengine.com ([66.111.4.26]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1q1FBm-001WNZ-VI for pgsql-general@lists.postgresql.org; Mon, 22 May 2023 23:43:47 +0000 Received: from compute2.internal (compute2.nyi.internal [10.202.2.46]) by mailout.nyi.internal (Postfix) with ESMTP id 3EDC15C00D7; Mon, 22 May 2023 19:43:39 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute2.internal (MEProxy); Mon, 22 May 2023 19:43:39 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h= cc:content-transfer-encoding:content-type:content-type:date:date :from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:sender:subject:subject:to:to; s=fm3; t= 1684799019; x=1684885419; bh=nB7ST2Fn3ACQ5MihCEbxvJaEX/a+g8Lz4/C /K9H8ZJo=; b=MkleSx1p3PbhvbnJhj0qRoKBw4CxamomAYBXTFsKG47nRQDjSLN rQgdZj8KN2bMUOyp0gBu1cSjDYjuCyW9RSkaoYyIuPEps9YCsYwWOQS55QfxgKN0 3mizvYF48Vxlsuw0qzq1Z2jJanyRZmA9ARlPUChHBhEiqlzVgd0J+cFURxd7+3WF GNokQw4DdW6i8t75NWca71wdqJEgcAPGquxJgEbgW5a9YHadMd9Aeh4jLnJ0MrXR KqrBo9q4p2B/em43S5fCUWEwTxVzEabQF/lvh+2kd/+WIkeYTruzp2IdSYll617J y321Ju4VTyqDKiQ7qs6e1BBSZlJ+9rFzE3w== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding:content-type :content-type:date:date:feedback-id:feedback-id:from:from :in-reply-to:in-reply-to:message-id:mime-version:references :reply-to:sender:subject:subject:to:to:x-me-proxy:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm1; t=1684799019; x= 1684885419; bh=nB7ST2Fn3ACQ5MihCEbxvJaEX/a+g8Lz4/C/K9H8ZJo=; b=R UWOS1GPgDEZmDBeH8tD2Z6Yrpc0AAmIv50U+YUm+zt2aS9NUhNkZ4QxBLxdgd6bQ Xn+0rImpEkzz03uAWDHWZggIiLk2h9exGh75vVmOUXjQw6ZldPpcC/9A2rrv2X11 oGOnrxBFB6hRC3oSBeTgmU+yRf+QZvBaJODelEyvIUE+Rh8ZAjJr39yAqRSEmmSZ A8PvKeRY7rL03rf6OqnDaq55lRvbwRMYV50IA17fdsOKWuwF16O8c5kxX94KpiSr cnzGwjNnP6eU/G4GEPNHBzLutiI+cTDkDFqs2AEXaLmmL5EdXnrISHlA7Ts3ELM/ YyOVIVVudr1UytH1tAQGA== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvhedrfeejvddgvdehucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne cujfgurhepkfffgggfuffvfhfhjggtgfesthejredttdefjeenucfhrhhomheptegurhhi rghnucfmlhgrvhgvrhcuoegrughrihgrnhdrkhhlrghvvghrsegrkhhlrghvvghrrdgtoh hmqeenucggtffrrghtthgvrhhnpeffudehtddugefgkeevudffheevvefhfeettdfhveei vdfgieeghfeiueeggffggeenucffohhmrghinhepphhoshhtghhrvghsqhhlrdhorhhgne cuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomheprggurhhi rghnrdhklhgrvhgvrhesrghklhgrvhgvrhdrtghomh X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Mon, 22 May 2023 19:43:38 -0400 (EDT) Message-ID: <8b4034c6-ca1b-b0bb-e067-685235775395@aklaver.com> Date: Mon, 22 May 2023 16:43:38 -0700 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.10.1 Subject: Re: 15 pg_upgrade with -j Content-Language: en-US To: Jeff Ross , 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> From: Adrian Klaver In-Reply-To: <5fdaee55-81df-4be8-73c9-8e496bd02368@openvistas.net> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 5/22/23 16:29, Jeff Ross wrote: > On 5/22/23 5:24 PM, Adrian Klaver wrote: >> On 5/22/23 16:20, Jeff Ross wrote: >>> Hello! >>> >> >> From docs: >> >> https://www.postgresql.org/docs/current/pgupgrade.html >> >> The --jobs option allows multiple CPU cores to be used for >> copying/linking of files and to dump and restore database schemas in >> parallel; a good place to start is the maximum of the number of CPU >> cores and tablespaces. This option can dramatically reduce the time to >> upgrade a multi-database server running on a multiprocessor machine. >> >> So is the 1400G mostly in one database in the cluster? >> >>> >>> The full commands we are using for pg_upgrade are pretty stock: > Yes, one big database with about 80 schemas and several other smaller > databases so -j should help, right? As I understand it no. That the parallelism is between databases not within a database. Further that 'database schemas' refers to schema as the overall database object definitions not the namespaces known as schemas in the database. > ' > Jeff -- Adrian Klaver adrian.klaver@aklaver.com