public inbox for [email protected]  

help / color / mirror / Atom feed

From: Jim Jones <[email protected]>
To: SATYANARAYANA NARLAPURAM <[email protected]>
Cc: PostgreSQL Hackers <[email protected]>
Subject: Re: Add max_wal_replay_size connection parameter to libpq
Date: Mon, 30 Mar 2026 09:45:07 +0200
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAHg+QDffk2NSTTvobAqqBmpN+DTZDJ3cdwsi5XxOUmY-MdKgwA@mail.gmail.com>
References: <[email protected]>
	<CAHg+QDeO4cbOKJSx0+yzD00a_1xv_z9dLrE4nKkxb1A+KEoKeg@mail.gmail.com>
	<[email protected]>
	<CAHg+QDffk2NSTTvobAqqBmpN+DTZDJ3cdwsi5XxOUmY-MdKgwA@mail.gmail.com>

Hi Satya

On 30/03/2026 01:51, SATYANARAYANA NARLAPURAM wrote:
> 
> What is the expectation from such a routing? Is it for freshness of data
> for the client or 
> freeing up the standby  from user connections so that it can catch up
> with primary?
> The paragraph described originally was talking about the freshness.

The motivation is closer to the former, but in a specific sense. The
concrete situations I have in mind are:

* Standbys that are I/O-bound and falling behind on replaying received WAL
* Standbys catching up after a pause
* Standbys running with recovery_min_apply_delay (intentionally delayed
replication).

In these cases, the client would read data older than what the standby
has already received. Routing around them is what the parameter enables.
The parameter does not measure how far the standby is behind the primary
-- it only measures locally buffered WAL that hasn't been applied yet. I
see I should have been clearer about that in the original email.

Let me know if I am missing something here.

Thanks!

Best, Jim

view thread (4+ messages)

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: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: Add max_wal_replay_size connection parameter to libpq
  In-Reply-To: <[email protected]>

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

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