Re: Remove duplicate table scan in logical apply worker and code refactoring - Mailing list pgsql-hackers

From Amit Kapila
Subject Re: Remove duplicate table scan in logical apply worker and code refactoring
Date
Msg-id CAA4eK1J-K5szWN_M5P7dkj2K_OGS9WkYzMY8oqmnhdCwSAkuWg@mail.gmail.com
Whole thread Raw
In response to RE: Remove duplicate table scan in logical apply worker and code refactoring  ("Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>)
List pgsql-hackers
On Thu, Aug 1, 2024 at 7:29 AM Hayato Kuroda (Fujitsu)
<kuroda.hayato@fujitsu.com> wrote:
>
> > Thanks for reviewing the patch, and your understanding is correct.
> >
> > Here is the updated patch 0001. I removed the comments as suggested by Amit.
> >
> > Since 0002 patch is only refactoring the code and I need some time to review
> > the comments for it, I will hold it until the 0001 is committed.
>
> Thanks for updating the patch. I did a performance testing with v2-0001.
>
> Before: 15.553 [s]
> After:  7.593 [s]
>

Thanks for the testing. I have pushed the patch.

--
With Regards,
Amit Kapila.



pgsql-hackers by date:

Previous
From: Richard Guo
Date:
Subject: Query results vary depending on the plan cache mode used
Next
From: "Hayato Kuroda (Fujitsu)"
Date:
Subject: RE: Conflict detection and logging in logical replication