Postgres Pro
Downloads
Home   >   mailing lists

Re: walsender performance regression due to logical decoding on standby changes - Mailing list pgsql-hackers

From Drouvot, Bertrand
Subject Re: walsender performance regression due to logical decoding on standby changes
Date
Msg-id 2c7a0c47-4b2c-5898-ee1c-8d99bf14ef8b@gmail.com
Whole thread Raw
In response to RE: walsender performance regression due to logical decoding on standby changes  ("Zhijie Hou (Fujitsu)" <houzj.fnst@fujitsu.com>)
List pgsql-hackers
Tree view 
Hi,

On 5/15/23 4:19 AM, Zhijie Hou (Fujitsu) wrote:
> On Friday, May 12, 2023 7:58 PM Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com> wrote:
>>
>> On Wed, May 10, 2023 at 3:23 PM Drouvot, Bertrand
>>
>> That's not the case with the attached v2 patch. Please have a look.
> 

Thanks for V2! It does look good to me and I like the fact that
WalSndWakeup() does not need to loop on all the Walsenders slot
anymore (for both the physical and logical cases).

> Thanks for updating the patch. I did some simple primary->standby replication test for the
> patch and can see the degradation doesn't happen in the replication after applying it[1].
> 

Thanks for the performance regression measurement!

Regards,

-- 
Bertrand Drouvot
PostgreSQL Contributors Team
RDS Open Source Databases
Amazon Web Services: https://aws.amazon.com

pgsql-hackers by date:

Previous
From: "Drouvot, Bertrand"
Date:
Subject: Re: Autogenerate some wait events code and documentation
Next
From: Ajin Cherian
Date:
Subject: Re: running logical replication as the subscription owner