Re: Parallelize WAL Sender and WAL receiver - Mailing list pgsql-admin

From Rui DeSousa
Subject Re: Parallelize WAL Sender and WAL receiver
Date
Msg-id 8805E20A-38B7-4D13-AB8C-95992471C4AD@icloud.com
Whole thread Raw
In response to Re: Parallelize WAL Sender and WAL receiver  (Karthik Yellapragada <karthik.yellapragada@gmail.com>)
List pgsql-admin

> On Sep 4, 2024, at 11:47 PM, Karthik Yellapragada <karthik.yellapragada@gmail.com> wrote:
>
> Appreciate the responses, the network is good.. around 350 MB/s between prinary and secondary, both primary and
secondaryin the same DC.  And it’s ASYC replication..  
>
> I see the issue when the writes are super heavy ,
> I am only thinking if we can add more processes that sends / receives the WALs , we can speed up the transfer rate of
WALsto the secondary.. 
>
> I understand the Apply can not be parallelized..

Sounds like you have 10GbE between the nodes? Are you sure it’s send rate? If so, I would look at the disk subsystem.


pgsql-admin by date:

Previous
From: Karthik Yellapragada
Date:
Subject: Re: Parallelize WAL Sender and WAL receiver
Next
From: Achilleas Mantzios - cloud
Date:
Subject: postgresql FDW vs dblink for DDL