Re: Replication lag
| От | Kellyn Pot'Vin-Gorman |
|---|---|
| Тема | Re: Replication lag |
| Дата | |
| Msg-id | CAN6wuX3mcGi8Zm4Xhgx1oeT2tBiUa905Cih1SiPdct-f_54n-Q@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Replication lag (Wasim Devale <wasimd60@gmail.com>) |
| Список | pgsql-admin |
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 | ||
On Thu, Apr 17, 2025 at 5:15 AM Wasim Devale <wasimd60@gmail.com> wrote:
Hi AllDoes wal_level = logical can resolve the issue of replication lag?On Thu, 17 Apr, 2025, 11:21 am Wasim Devale, <wasimd60@gmail.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 offAnd maximum streaming delay is set to -1Thanks,Wasim
В списке pgsql-admin по дате отправления: