Assunto: Replication lag

[Marcus Vinicius Castro <marcus_castro@xxxxxxxxxxxx>]

First you have to check the indexes and the query.

After that you can research on Google ways to increase the performance in database.

Best regards!

Yahoo Mail: Busque, organize e aumente sua produtividade

Em qui., 17 17e abr. 17e 2025 às 2:52, Wasim Devale

<wasimd60@xxxxxxxxx> escreveu:

Hi everyone,

We have a setup of primary and replica database. We are using the replica as read only purpose. But the queries are long running queries that takes 30 minutes to complete.

Do we have any settings in place that will not show replication lag and the queries also executes on replica database without competition on WAL reply?

The settings:

Hot standby is off

And maximum streaming delay is set to -1

Thanks,

Wasim