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 1uRZ5i-00DRhp-KR for pgsql-performance@arkaria.postgresql.org; Tue, 17 Jun 2025 16:23:18 +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 1uRZ5g-00B8oJ-MF for pgsql-performance@arkaria.postgresql.org; Tue, 17 Jun 2025 16:23:17 +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 1uRZ5g-00B8oA-C9 for pgsql-performance@lists.postgresql.org; Tue, 17 Jun 2025 16:23:17 +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 1uRZ5e-002WKS-2H for pgsql-performance@lists.postgresql.org; Tue, 17 Jun 2025 16:23:15 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmx.net; s=s31663417; t=1750177391; x=1750782191; i=jimis@gmx.net; bh=PZ05U/BeAeHScqcCndGggCZMn6L4ziOM6POIc2TJmMk=; 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=T1ngKQsGw6f9FlInkDIN3wrttJ+dQqgnO1QFCGCz+RL+JCpjXDtV9o7y1pm8EwQo TrBWsPVBY9l2n6LfhzCOi5xSrvJ9BYmdKLmeVSxR+VW4wY/viJ/7ib+UZ3n379tMQ namEDQAXetdX85wS12cuTwB1HCnYloPhGWxkJ1l+9ixqf+v+tcmnDZ9VZEmKI2Vmt kDjtvRRom/Zs/bH9/V/TNlyLJMPvdDDzjuOSpS9EdePR9kiMs1rjE6f7MgqKeNDpg L4f8aBAeT6G6tqllR6GqJKYhSA4PvmrdlNCX4RZkbUpGyi2SBLkL1gpNb+ZjFIfiD JnJCxA2wpmKqZ01pjg== 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 1MeU4s-1v1imp0qmK-00dJ7y; Tue, 17 Jun 2025 18:23:11 +0200 Date: Tue, 17 Jun 2025 18:23:09 +0200 (CEST) From: Dimitrios Apostolou To: =?UTF-8?Q?Fr=C3=A9d=C3=A9ric_Yhuel?= cc: pgsql-performance@lists.postgresql.org, bruce@momjian.us, Christophe Courtois Subject: Re: [PATCH] ALTER TABLE ADD FOREIGN KEY to partitioned table, is not parallelized In-Reply-To: Message-ID: <4749eb1e-0fd6-f55b-034a-d3c0bbe5ba8b@gmx.net> References: <5f002654-92e9-8032-3e1a-134461b4e819@gmx.net> <90e55c6b-3d79-4bf8-8874-a64dd10a0286@dalibo.com> MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII; format=flowed X-Provags-ID: V03:K1:2IYEbgFKlYb2sHqLVNCW0kYwfyqUbWSxQ9xyMU5ENR/HaTRv5nv 7GeZHZOcJA/fLbUhJtACmFT247Qgq7smuqpA/mqsHc9ERRHYyWZpgM2Ek7A7zOOgG8RCrBx uhGfLQMMLn8VYg7WqhTajBMqSVTyW5lTWFlnZNfjUT0lzTFLgBAIAZuEgM4UhMBPksCD8d8 l1uXlgQUB9UZL4ClANK2w== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:XjwetqZ4TSQ=;vc9SHunAPzDNOsOojeaSvPRkZm7 foAdRPHcme2cokBac9+7AppXcl87h89XcE8hcIVgOm4eXpI2ngsE4GahV8PUhbrL4O/0BKgZu GFS3Fn2BE+qZ8437SMjUuWaLVcsC5CXAbP7g0CFo4GVsLsF1PoR5FmREAaT1Wh2Xj51xlkWI8 IcmvQNiv+0V71Altn89q9bruBTXoCVrmDz04Du8N4v5nAKqd2R9hcgHX2c5P0ZlGvxKqA1tzu aCfG77/Gnbo2Y3e0A2LVB3M/ZX2fwHvojXOxmzRn3Kq03U+AzmGmv+My2Szy+cP1FCuNDGOcL SPnSFEAiCV1kY4Ig66PO29Nt4s80df2PoFn/N2XLmKakmk3Ouae2liW5D/vYpNfF12ge7HALn ZdRPKnSiXYguwP3XaqokIYf4CzXcjQG4XKTACJBEtWBhPdVH8SkgGr70LaM8p4R53dpiABJPJ P/ksvI85RjjBKrM5WZLggbQMGxN7lmJbUWZy0sHD0bQ5IAGpRdvvlf9PMzXJ4FwNvnxXh7vz/ 8bZKSDt/hEqJMB/eURP1e90PZR2OerRGyOMA1Pg+WGKZUuuXPkSMl+EISvRJ+82tyDEf2U9LB 6A8p9J+tBRnSTQ611nBkDB3aI8LdASqWoBLoMK7bAD735HDn7cerx+ceK+vEcagPUgSEC1Vls ELLnNsaDYoZJBAg55TdP+JTsytx0fNWx9SddV6BgzYT4ikLiJWlRpkUN/uM39dranab/OETtI 96Eo7uWX7zrUUseRgBWmIfYHKO8ol8XVQdJZaw0VNwtlnFdAGV1xmq64eZBDrkF0pDsvAe7Zy Qn6deMjY5Ib+wM9y5kgfiAO53O0cqhUf2yQYbXd5d7ZYfUEw8jVzFGPHVxS9liNDxZKSNKzeV 6KvE63xFis824SnZj9tcNkx0RlpAuK5Uuvfw+mBX8f/nKlhVbWNr8huxe+GILHhB6++acaIFk QSaR20Zqo9isNE4vyeQfbGLNuOrcZyyCNX5a7Lm38jQTH5FU0lfj3wl018GWqvpZZpB506Q05 2mSGMGUzm2GOoEmQxB8i0s4qxXbFMgWFQUgSj3e0LYDLYiuYuYe5eXhyqe29rbRY4w+UVXFLp 9XNmj7uTpgIp42jDr0WDU764U0g+orhMTMBHWw9/5NTJ9xmxEZfja/37ide7tPUlCDMOsPILc ID3fbKsBchLtgjSU3B5DHWyv0L70ZDkIq2NSjO9YaNMV5L0s8BMo1SzuXQsbBdAGst10P+y5W 8fltEHqIwYJgBMWPGZIH1ZDS8GCZ3obka0hxLxOm7NOJzCL51S4Nf4d07+PJBvBSIhkGtElep /A25hxHJLvsntbPTSd055d4jFwTQ8EsiWr23hlGdwCms1EMmOnZG88z36kx5jAU+YnX3pM9fW ESugZVLe/uJhM4Vtno5h5tskMzjbq1GgLNmhRFbrJtyu0MlzQjx/oMla4AhHz3X8K/61zk3Q0 XODaUggZYliBYd1oc9BxWJSgLZLEl+UExehyDfnJtP43B9SSidi6WLPv47z6HNa4/BWXmvREv 27wjkCIsIfi3YOmMNZWT+n6naMPgiKrptKDiu+JKgFQ21kh9jtjzM9qCidfJFt9EcTPnJ8w1C njAMQVI+YabF3J+dFhvdYvoDw0bvO2EDFbErTwp/Cea7r6NmYbeOwCKo1Gb4TCw1l8lqQIhPv EAPlfU9/j4eRb14p8aiZWzXCdbQRtqiufF0rILJQ2o3WKZg0adcFnueYHAMKL7Sqh6iL86mMv G2WH5yzEbzIuPkW0xE9a0HhHxzjnP2F/dyfQm4vuj8G7194hW0aXf18uIrr9m3+ibCvFVatJZ VtXYasTDXdJzXt5nCkhO8EIooNR0oJ3ahVLrIBBph5Yh3Vtwg+Ki8lw0Lic73+jz2/pJVkChE noTwBQ568s45EnmXRK/FqVu7R41TUyJUzZwFoVM5nzdpMfgu14/NYgpSVYrvrL5/ZdHgnetTi IL02viKgP06MBAj2nVoZTwb25a8fiXceNXoGFtBLWudlLYfnq1heMAzGKDQmRkPCTkLmz4jhp P+pKAn7eVdLDVxvdWEUKAggCjbbdp7ajJRBhIxWzmSpJ7zgArsZBN1J5sUZUdWLp81qFGzYr+ qgyNR74qhzArYMK1G/fvKhws7HitpF8Mh7Ne4Z7LwspTu5xI54+yoSwifcO5wUxnaub1/JRtB 9b84/COa1CPv3W1wx5Yf8/+ETKCQD01NHKt66y3QEqBXfwB78LJWXjKg1faP/hFE5OIwUzegf YpRFlW4CvN+97mhT4SPl+pgXxYiUvM4MQsQKhHIqon0xL7h2UrulL8C5Kfeagg0zz3H1McZMs m0aDbZQuXVOutFRXz45IZwh2pzsptXuzg8Mv1xGRtFN2bDnfSNHPEi1Zb4UEmmGx2rGtuVphD 9lQWaT0//0pdeVu4CH69MsgO+HmA5XAXAbzSaIrg8N06R1au0TPJShAGgle5nBvqt//yt2juO 9X4Zivis7CuDTfirok5DsOe20UoJiqdpbs9Au2p04/1Q6IEyhDy7PA0CSxZvtoYmMsS/B3IPd cUyUUXBPvEkc8kXLU+oVKUwQ7WHzko0xkw6gOUXnj5h+0N9GrurJF7IN5TygUi+LmMEotFenf i25MV2QKYuvXhvhcVJfRX+dejePlkhFeingCGpvb5KPJXNwy0Hi42g6asfOCw/H7qVuHbDEp6 MSq0TwArzQDKLKhwn/+A2hXt0QTIN7DuMROCkBhI6HoleZ5XM9USbaK1u1fi+xpTrg+XwE3iU PiBmlg5+rX+7tc9+gnSzl0OI9l+HV/ueHcKsHGtFJF6Mtm7S/KY8A63YjYg+OxCcU2vBXJ5sm VmWCIU7t8v55QKd5XGh2NUHEpYfxVJSa0wq2FF/m7Y9+CTpb+HpbD9xaWkKKWX3vTMBAKKSMs rAptDReaA/xheNXCzmskjW/qparF7smAEHzJMhq8okwvoQ7KuysDWfOlwZ4teMgDQxEJvUa1u zQH21RXkhwT0Kbe+ULLhXTy4+Dwmz9dbSFMX4iP33GJKCxe29FToYO1NSEaQiAr0NL8Ej/95w KoKtg182N3YsSUq1Z9Hc9RWgKTNXR9SeeynH2+uM4Y4HOLXiR6xyt0k3Yuj46kZh2aUMhCb0v w1zDOy2nptQvkAAu+fAPiEzry0hBo22QSBGEgVW7maPAN0A7wWHthcGIWBDU0jrZrLD5iM85h 9a4pJWahEoJs72Wemy0EmH5NrIygwxa4YiXnUlXNgU9VWQw== Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > > FWIW I implemented a pg_restore --freeze patch, see attached. It needs= =20 > another patch of mine from [1] that implements pg_restore --data-only=20 > --clean, which for parallel restores encases each COPY in its own transa= ction=20 > and prepends it with a TRUNCATE. All feedback is welcome. > > [1] https://www.postgresql.org/message-id/c61263f2-7472-5dd8-703d-01e683= 421f61%40gmx.net > > It works really fast for the data, and I see that some, but not all item= s=20 > from section=3Dpost-data, start parallel plans. For example I see CREATE= INDEX=20 > spawns parallel workers. I added it to July's commitfest, mostly to trigger discussion around the= =20 issue. https://commitfest.postgresql.org/patch/5826/ Not sure how to mark on the commitfest page that the patch requires=20 another patch from another commitfest entry. Dimitris