Re: Synchronizing slots from primary to standby

From: "Drouvot, Bertrand" <bertranddrouvot(dot)pg(at)gmail(dot)com>
To: shveta malik <shveta(dot)malik(at)gmail(dot)com>
Cc: Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com>, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, Peter Eisentraut <peter(dot)eisentraut(at)enterprisedb(dot)com>, Bruce Momjian <bruce(at)momjian(dot)us>, Ashutosh Sharma <ashu(dot)coek88(at)gmail(dot)com>, Andres Freund <andres(at)anarazel(dot)de>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Synchronizing slots from primary to standby
Date: 2023-08-08 05:41:24
Message-ID: d7cf51bf-2723-4fd5-9432-b124ad44c935@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

On 8/8/23 7:01 AM, shveta malik wrote:
> On Mon, Aug 7, 2023 at 3:17 PM Drouvot, Bertrand
> <bertranddrouvot(dot)pg(at)gmail(dot)com> wrote:
>>
>> Hi,
>>
>> On 8/4/23 1:32 PM, shveta malik wrote:
>>> On Fri, Aug 4, 2023 at 2:44 PM Drouvot, Bertrand
>>> <bertranddrouvot(dot)pg(at)gmail(dot)com> wrote:
>>>> On 7/28/23 4:39 PM, Bharath Rupireddy wrote:
>>
>
> Agreed. That is why in v10,v11 patches, we have different infra for
> sync-slot worker i.e. it is not relying on "logical replication
> background worker" anymore.

yeah saw that, looks like the right way to go to me.

>> Maybe we should start some tests/benchmark with only one sync worker to get numbers
>> and start from there?
>
> Yes, we can do that performance testing to figure out the difference
> between the two modes. I will try to get some statistics on this.
>

Great, thanks!

Regards,

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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2023-08-08 05:52:42 Re: Incorrect handling of OOM in WAL replay leading to data loss
Previous Message Drouvot, Bertrand 2023-08-08 05:37:42 Re: WIP: new system catalog pg_wait_event