Re: Fundamental scheduling bug in parallel restore of partitioned tables - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Fundamental scheduling bug in parallel restore of partitioned tables
Date
Msg-id 1283669.1744652646@sss.pgh.pa.us
Whole thread Raw
In response to Re: Fundamental scheduling bug in parallel restore of partitioned tables  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Fundamental scheduling bug in parallel restore of partitioned tables
Re: Fundamental scheduling bug in parallel restore of partitioned tables
List pgsql-hackers
I wrote:
> Here's a draft patch for this.  It seems to fix the problem in
> light testing.

I realized that the "repro" I had for this isn't testing the same
thing that Dimitrios is seeing; what it is exposing looks more like
a bug or at least a behavioral change due to the v18 work to record
not-null constraints in pg_constraint [1].  So my patch may fix his
problem or it may not.  It would be good to have a reproducer that
fails (not necessarily every time) in v17 or earlier.

In addition to that uncertainty, pushing the patch now would get in
the way of identifying what's really going on at [1].  So I'm going
to sit on it for now, and maybe it's going to turn into v19 material.

            regards, tom lane

[1] https://www.postgresql.org/message-id/1280408.1744650810%40sss.pgh.pa.us



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [PING] [PATCH v2] parallel pg_restore: avoid disk seeks when jumping short distance forward
Next
From: Kirill Reshke
Date:
Subject: Re: Built-in Raft replication