Re: Parallel Apply
Amit Kapila <amit.kapila16@gmail.com>
From: Amit Kapila <amit.kapila16@gmail.com>
To: Dilip Kumar <dilipbalaut@gmail.com>
Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2025-09-05T11:14:06Z
Lists: pgsql-hackers
On Fri, Sep 5, 2025 at 2:59 PM Dilip Kumar <dilipbalaut@gmail.com> wrote: > > On Mon, Aug 11, 2025 at 10:16 AM Amit Kapila <amit.kapila16@gmail.com> wrote: > > > > +1 for the idea. So I see we already have the parallel apply workers > for the large streaming transaction so I am trying to think what > additional problem we need to solve here. IIUC we are actually > parallely applying the transaction which were actually running > parallel on the publisher and commits are actually applied in serial > order. Whereas now we are trying to parallel apply the small > transactions so we are not controlling the commit apply order at the > leader worker so we need extra handling of dependency and also we need > to track which transaction we need to apply and which we need to skip > after the restarts as well. Is that right? > Right. > I am reading the proposal and POC patch in more detail to get the > fundamentals of the design and will share my thoughts. > Thanks. -- With Regards, Amit Kapila.