public inbox for [email protected]  

help / color / mirror / Atom feed

From: David Okeamah <[email protected]>
To: Wasim Devale <[email protected]>
To: pgsql-admin <[email protected]>
To: Pgsql-admin <[email protected]>
Subject: Re: Replication lag
Date: Fri, 23 May 2025 08:08:33 +0000
Message-ID: <AS4PR03MB8506AFDDDE719261B0E1ADDDF798A@AS4PR03MB8506.eurprd03.prod.outlook.com> (raw)
In-Reply-To: <CAB5fag6D_UdYOipnhH+n0cFimHjxjvP1fPvh_qZWH7q+1dQ+GQ@mail.gmail.com>
References: <CAB5fag6D_UdYOipnhH+n0cFimHjxjvP1fPvh_qZWH7q+1dQ+GQ@mail.gmail.com>

Query Execution and Reply WAL Coexistence in PostgreSQL


 Wasim,


Thanks for your question.


Yes, PostgreSQL does support concurrent WAL replay and read query execution on replicas through its hot standby feature. By setting hot_standby = on, a replica can serve read-only queries while applying WAL files from the primary via streaming replication.


However, there are a few caveats:


  *   Read queries on the standby may be canceled if they conflict with recovery operations. This behavior can be tuned using parameters like max_standby_streaming_delay and hot_standby_feedback.
  *   Unlike Oracle GoldenGate, PostgreSQL’s native logical replication is more limited in terms of conflict resolution and cross-version replication, though tools like pglogical or Debezium can bridge those gaps for more complex use cases.



Best regards,

David Okeamah



DAVID OKEAMAH,DEVELOPER
________________________________
From: Wasim Devale <[email protected]>
Sent: Friday, May 23, 2025 8:13:10 AM
To: pgsql-admin <[email protected]>; Pgsql-admin <[email protected]>
Subject: Replication lag

Hello,

Reply wal and query execution on replica can coexists?

Golden gate in oracle has this feature that they can coexists but in postgresql do we have any provision like this.

Please assist.

Thanks,
Wasim

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: Replication lag
  In-Reply-To: <AS4PR03MB8506AFDDDE719261B0E1ADDDF798A@AS4PR03MB8506.eurprd03.prod.outlook.com>

* 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