Re: walsender performance regression due to logical decoding on standby changes
От
Drouvot, Bertrand
Тема
Re: walsender performance regression due to logical decoding on standby changes
Дата
Msg-id
2c7a0c47-4b2c-5898-ee1c-8d99bf14ef8b@gmail.com
Ответ на
RE: walsender performance regression due to logical decoding on standby changes (Zhijie Hou (Fujitsu))
Список
Дерево обсуждения
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
Дата: