Horton

Re: Fundamental scheduling bug in parallel restore of partitioned tables

Dimitrios Apostolou <jimis@gmx.net>

View thread View on postgr.es
From: Dimitrios Apostolou <jimis@gmx.net>
To: Tom Lane <tgl@sss.pgh.pa.us>, Dimitrios Apostolou <jimis@gmx.net>
Cc: pgsql-hackers@lists.postgresql.org, Andres Freund <andres@anarazel.de>
Date: 2025-04-15T16:35:48Z
Lists: pgsql-hackers 
On 15 April 2025 18:18:41 CEST, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>Dimitrios Apostolou <jimis@gmx.net> writes:
>> I only got the "ERROR: deadlock detected" message once, with pg_restore 
>> compiled from master branch.
>
>Oh, hmm ... do you recall just when on the master branch?  I'm
>wondering if it was before or after 14e87ffa5 (2024-11-08).
>If it was after, then it might have been subject to the same
>issue with not-null constraints that I ran into.
>
>			regards, tom lane

Definitely after.

Commits

  1. Elide not-null constraint checks on child tables during PK creation