Re: Parallel Apply
Andrei Lepikhov <lepihov@gmail.com>
From: Andrei Lepikhov <lepihov@gmail.com>
To: Amit Kapila <amit.kapila16@gmail.com>,
PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2025-08-12T06:34:46Z
Lists: pgsql-hackers
On 11/8/2025 06:45, Amit Kapila wrote: > The core idea is that the leader apply worker ensures the following: > a. Identifies dependencies between transactions. b. Coordinates > parallel workers to apply independent transactions concurrently. c. > Ensures correct ordering for dependent transactions. Dependency detection may be quite an expensive operation. What about a 'positive' approach - deadlock detection on replica and, restart apply of a record that should be applied later? Have you thought about this way? What are the pros and cons here? Do you envision common cases where such a deadlock will be frequent? -- regards, Andrei Lepikhov