pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: SASIKUMAR Devaraj <sashikumard@yahoo.com>
To: scott_ribe@elevated-dev.com
Cc: Laurenz Albe <laurenz.albe@cybertec.at>
Cc: Bryon Roché <kain@kain.org>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Re: How to speed WAL apply in destination
Date: Sat, 10 Dec 2022 01:37:58 +0000 (UTC)
Message-ID: <230318450.2704250.1670636278607@mail.yahoo.com> (raw)
In-Reply-To: <C5A289F2-237A-4FA0-B0A0-6311DE428A4E@elevated-dev.com>
References: <364439211.2445507.1670562179127.ref@mail.yahoo.com>
	<364439211.2445507.1670562179127@mail.yahoo.com>
	<1E6A35F6-6866-4FDB-8CE8-38C328FF1865@kain.org>
	<44581ceb3c9c96f48e131ed3de33389db07317e9.camel@cybertec.at>
	<203270855.2602687.1670583423055@mail.yahoo.com>
	<C5A289F2-237A-4FA0-B0A0-6311DE428A4E@elevated-dev.com>

Hi
This happens only during heavy data load. Other time it is normal.  

Sent from Yahoo Mail on Android 
 
  On Fri, Dec 9, 2022 at 7:52 PM, Scott Ribe<scott_ribe@elevated-dev.com> wrote:   > On Dec 9, 2022, at 4:57 AM, SASIKUMAR Devaraj <sashikumard@yahoo.com> wrote:
> 
> 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 

- have you checked network throughput between the 2 nodes?

- are the 2 nodes similar hardware configurations?



  

view thread (15+ messages)  latest in thread

Message-ID: <230318450.2704250.1670636278607@mail.yahoo.com>
Permalink:  ../230318450.2704250.1670636278607@mail.yahoo.com/
Also on:    postgresql.org/message-id/230318450.2704250.1670636278607@mail.yahoo.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: sashikumard@yahoo.com, scott_ribe@elevated-dev.com, laurenz.albe@cybertec.at, kain@kain.org, pgsql-admin@lists.postgresql.org
  Subject: Re: How to speed WAL apply in destination
  In-Reply-To: <230318450.2704250.1670636278607@mail.yahoo.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox