Hey Wasim,
You've already checked the lag information in pg_stat_replication, pg_stat_statements and pg_stat_activity?
Is there any delay in the setup that might be causing the lag?
max_standby_streaming_delay and/or max_standby_archive_delay
From what I understand on logical replication, that is for specific tables for row level replication and is not for a full database replication. I believe that's a change that will require a restart, (wal change...)
wal_level = logical |
| | Kellyn Gorman |
| |
Hi All
Does wal_level = logical can resolve the issue of replication lag?
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
