Horton

Re: Fundamental scheduling bug in parallel restore of partitioned tables

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Dimitrios Apostolou <jimis@gmx.net>
Cc: pgsql-hackers@lists.postgresql.org, Andres Freund <andres@anarazel.de>
Date: 2025-04-15T16:18:41Z
Lists: pgsql-hackers 
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

Commits

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