During certain interval there is huge WAL file generation f3om primary around 300gb/hr which delays sync in secondary by atleast 30 mins. Other time it is normal
On Fri, Dec 9, 2022 at 4:20 PM, Laurenz Albe<laurenz.albe@xxxxxxxxxxx> wrote:
You can use "ionice" and "chrt" to make WAL writer and WAL sender
real time I/O priority. Also, you should consider increasing the
network throughput between the primary and the secondary. What
kind of network is there? Is any of the servers a virtual machine?
Most of the hypervisors throttle network adapters of the virtual
machines. Default network speed for VMWare VMs is 1Gb/sec. I think
that the same is true for KVM. You should check the disk bandwidth
consumption by using sar -d or atop -d. The first step would be to
use iperf3 to check the network throughput.
-- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com