Thread: Replication lag

Replication lag

From
Wasim Devale
Date:
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

Re: Replication lag

From
Dionysios-Charalampos Vythoulkas
Date:

On streaming replication yes, you can perform read-only queries.

On logical replication, as far as I know you can also run write queries, but you have to be careful to keep the data consistent.

On Παρασκευή, 23 Μαΐου 2025 10:13:10 Π.Μ. EEST Wasim Devale wrote:

> 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