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 1u0ifa-006ZPp-UI for pgsql-general@arkaria.postgresql.org; Fri, 04 Apr 2025 15:09:22 +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 1u0ifZ-001AZ6-4S for pgsql-general@arkaria.postgresql.org; Fri, 04 Apr 2025 15:09:21 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1u0ifY-001AYx-Oz for pgsql-general@lists.postgresql.org; Fri, 04 Apr 2025 15:09:20 +0000 Received: from mout.gmx.net ([212.227.15.19]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1u0ifW-002vza-2Y for pgsql-general@lists.postgresql.org; Fri, 04 Apr 2025 15:09:19 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmx.net; s=s31663417; t=1743779356; x=1744384156; i=jimis@gmx.net; bh=YMwdrWhwLF52195KROyCPRolGzz+MShxfyyenINzPo0=; h=X-UI-Sender-Class:Date:From:To:cc:Subject:In-Reply-To:Message-ID: References:MIME-Version:Content-Type:Content-Transfer-Encoding:cc: content-transfer-encoding:content-type:date:from:message-id: mime-version:reply-to:subject:to; b=pGvL/srF7kL+7Oq6+ealgmbhSVQ39D9huaWezDOBzS2x5Wyv/pXs3UOIJPtDE04K I+DegzkZnShNczaAeSgHaKc6az1sQcoSogWN1W8loWBUpotYPVVk3d4TQYp7jZv7J Iwoy6AVsc1mR2dJzKaeHVybIWzmWU+v5ZfjNFwQVZdouXTkaz0xSVM4lWj92oCiz1 2+gGD/OGLGq1NdNB60KE2ufa9XQwn/IhZCPXhvDpzQ1p3oZmmDK+TzdsDn102UV4d 8uB6FZ5/l1pKbXtcGJRHclhH/m4xLDpSu/83OXFi4qOHWoeDX8jywjE9OuNMLNbuw UWkB8L7vSLR7Goh+Ow== X-UI-Sender-Class: 724b4f7f-cbec-4199-ad4e-598c01a50d3a Received: from [10.9.70.81] ([185.55.106.54]) by mail.gmx.net (mrgmx005 [212.227.17.190]) with ESMTPSA (Nemesis) id 1ML9yS-1tiV3u2mN0-00USXu; Fri, 04 Apr 2025 17:09:16 +0200 Date: Fri, 4 Apr 2025 17:09:14 +0200 (CEST) From: Dimitrios Apostolou To: Adrian Klaver cc: pgsql-general@lists.postgresql.org Subject: Re: Performance issues during pg_restore -j with big partitioned table In-Reply-To: Message-ID: References: <84379bfb-bbda-84e6-cacc-e863ba9d6c37@gmx.net> <67469c1c-38bc-7d94-918a-67033f5dd731@gmx.net> MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII; format=flowed X-Provags-ID: V03:K1:i0QjSaA5lp+59JiUYY57ujJRLdTApEV92yc7gmDOuUmV0sIOGBw dX22jgkr6vt/A1EK/RwEJtuE2pDt8ixF0nsoag6plZlauzRNwRf8uhJQgUP/dJ3GqttjMKz GdwCfsn8lVYZ0rzscyQt55OJ3/uScYRkf3Wh0ZdXVVhSMZR0tZvGihHS2wWJCH7WPHXvQba sxEJuZ2JYikvyN5AvUEWg== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:YM0zMn6oXOM=;SqNy3dFvFE7IfDM4xPcQyIKU77w RI3Z5YdHSiINS3XtwUscyrXIMGCFrWEAjp3AbWHI8UULtjAUk9QSAeFvl4rBWy19zkxpPAWiO IMIGKI2UVH/EoN1kyavX9kRzHucenykB17Z8UxqoB6IizXKAooNLWrWR4/vJ9lVBmm4EAQvBN tPQdRez+blbQM9ae99f81/vlvQsenTXXlG2CeP2Q2iPPO3gfMYRydQdc0/ozWkeKYHvkB+NuN zWKwmQjL2iOBSIIV0fA841hn0ftqVeA9YwD7SWZLXKFQFvfVIVwk3fYuqPzYMe98cr5YT9Rc9 6ly5XjkfjiwVqPRw9PE9n0bjyPi2j+5lyyjdBYI7GHjxE5GfGKTOK+UT2YhjuUE1uiGY5y019 0wBl0L+K2Ti94TwXi5s//crQ3IYmGXEtN5RB+hnr4DpTIX4X8A1nBhpkx+6AwmXp3n1dxJPId E/cF/6+/8l5v+a6whyYIVKt6VBKAwoLDQQW4TrPZ8LgqzjZWpUjtB6P696sNAg5Bi2ytlzM37 6DdOOchwSXZszIWuxwXVdcapokL9SenqXMLr17xy+LMHho0+sMc/5aA9jXqgQobpNf4W07rdm DPRY9npO44BgJnmL2Xiidqz0GWMmSgwElxy54W1MlMQtFijRjiq33MmaTRMY0tqwwJj0FyTLO N9X1O2gMRXzSnZ4NwW3aITdnUR5/kfguQ/wBHb4d36e2dxZdO3W5IPaTx5no2KoDXqbCZN/IP F1PK/1+NLPFdNcBfKUCfPY7jbamvVtN8jjZlyOH7FQGofD1txDtbP9QY9shDjaPn1HbtBDFUy TPX+ct8w9Ugl4u37QME1f+sbh6OOl4gIS+HQpSa8khGA8OzFeqxHV+wtM+2ecscVioQBlZ/0q OCZG2wV3XcnC3flra48aANZFPzYNFsit22LnVoyuR/3gV+VPiGlqD8HeXltjI91N/OvEDeAKF +zlwxsKtdUJk0T/6FXnTRPs8deduA5GsXY4nYVvAeEEOv6GIzBmD4943vc+vQLsbVWNFIZZJg GFOTzjZSeLJTbi9ZiOOZv4Du6Jt6Z7SfQILJdLfOoTOF0Txh0me/DKZo4CNDkPye+L8rWTQhJ MBfqHmPCgqnoBPbDpeD0518T49ZWRJEq9dI/Di2bLb8TLjfRl30C52IG2FOj0Y2DeAa5wvcvs KYwEyRViwIqhM7bLAS8KRqsj95Fp9AW520FDqVGQv0Gv0hpQFEDIOY7LyMiw+/ZyWpKpG35wh oLRmAaBvCNawirYcTLLHvLdxfJT3k6JPgzktt5jNEtv0YemlizPrhQNsxWuWeAxSWNIZD1fy4 W4H/aW0HoryHU/SCaK/kDRokLmlvzKmLk0luWRNFgNOLiXrsDCZ7EkEA6LMnjYCj5ZH4IG9Xx r2aX5fmW9/IsM3buIb5Wm9vM18IKg0YPpYac2oC1nLbVqBpaUsFfs8mxJlFhfwp1Xbv/dDIKC 4ou2mRg== Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, 4 Apr 2025, Adrian Klaver wrote: > On 4/4/25 06:13, Dimitrios Apostolou wrote: >> On Wed, 2 Apr 2025, Dimitrios Apostolou wrote: >> > >> Bug? This happened on a postgres compiled from last week's master bran= ch. > > Are you talking about the dev version? In this thread, yes. My mistake I didn't mention it from the start. I compiled it in order to see if the problems I mentioned in my previous thread were fixed. Dimitris