Re: walsender performance regression due to logical decoding on standby changes

Поиск
Список
Период
Сортировка
Искать
От
Drouvot, Bertrand
Тема
Re: walsender performance regression due to logical decoding on standby changes
Дата
в 08:41:12
Msg-id
2c7a0c47-4b2c-5898-ee1c-8d99bf14ef8b@gmail.com
Ответ на
Список
Дерево обсуждения
walsender performance regression due to logical decoding on standby changes Andres Freund <andres@anarazel.de>
Re: walsender performance regression due to logical decoding on standby changes Jeff Davis <pgsql@j-davis.com>
Re: walsender performance regression due to logical decoding on standby changes Andres Freund <andres@anarazel.de>
Re: walsender performance regression due to logical decoding on standby changes "Drouvot, Bertrand" <bertranddrouvot.pg@gmail.com>
Re: walsender performance regression due to logical decoding on standby changes Andres Freund <andres@anarazel.de>
Re: walsender performance regression due to logical decoding on standby changes Jeff Davis <pgsql@j-davis.com>
Re: walsender performance regression due to logical decoding on standby changes Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: walsender performance regression due to logical decoding on standby changes "Drouvot, Bertrand" <bertranddrouvot.pg@gmail.com>
Re: walsender performance regression due to logical decoding on standby changes Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: walsender performance regression due to logical decoding on standby changes Thomas Munro <thomas.munro@gmail.com>
Re: walsender performance regression due to logical decoding on standby changes Masahiko Sawada <sawada.mshk@gmail.com>
Re: walsender performance regression due to logical decoding on standby changes Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: walsender performance regression due to logical decoding on standby changes Andres Freund <andres@anarazel.de>
Re: walsender performance regression due to logical decoding on standby changes Andres Freund <andres@anarazel.de>
Re: walsender performance regression due to logical decoding on standby changes Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: walsender performance regression due to logical decoding on standby changes Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: walsender performance regression due to logical decoding on standby changes Andres Freund <andres@anarazel.de>
RE: walsender performance regression due to logical decoding on standby changes "Zhijie Hou (Fujitsu)" <houzj.fnst@fujitsu.com>
Re: walsender performance regression due to logical decoding on standby changes Andres Freund <andres@anarazel.de>
RE: walsender performance regression due to logical decoding on standby changes "Zhijie Hou (Fujitsu)" <houzj.fnst@fujitsu.com>
Re: walsender performance regression due to logical decoding on standby changes Andres Freund <andres@anarazel.de>
RE: walsender performance regression due to logical decoding on standby changes "Zhijie Hou (Fujitsu)" <houzj.fnst@fujitsu.com>
Re: walsender performance regression due to logical decoding on standby changes Andres Freund <andres@anarazel.de>
Re: walsender performance regression due to logical decoding on standby changes "Drouvot, Bertrand" <bertranddrouvot.pg@gmail.com>
RE: walsender performance regression due to logical decoding on standby changes "Zhijie Hou (Fujitsu)" <houzj.fnst@fujitsu.com>
Re: walsender performance regression due to logical decoding on standby changes "Drouvot, Bertrand" <bertranddrouvot.pg@gmail.com>
RE: walsender performance regression due to logical decoding on standby changes "Zhijie Hou (Fujitsu)" <houzj.fnst@fujitsu.com>
Re: walsender performance regression due to logical decoding on standby changes Amit Kapila <amit.kapila16@gmail.com>
Re: walsender performance regression due to logical decoding on standby changes Masahiko Sawada <sawada.mshk@gmail.com>
RE: walsender performance regression due to logical decoding on standby changes "Zhijie Hou (Fujitsu)" <houzj.fnst@fujitsu.com>
Re: walsender performance regression due to logical decoding on standby changes Andres Freund <andres@anarazel.de>
Hi,

On 5/15/23 4:19 AM, Zhijie Hou (Fujitsu) wrote:
> On Friday, May 12, 2023 7:58 PM Bharath Rupireddy  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 по дате отправления
От: Drouvot, Bertrand
Дата:
От: Ajin Cherian
Дата:
FAQ