Hi All
Does wal_level = logical can resolve the issue of replication lag?
On Thu, 17 Apr, 2025, 11:21 am Wasim Devale, <wasimd60(at)gmail(dot)com> wrote:
> 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
>