Re: Replication lag

Поиск
Список
Период
Сортировка
От Wasim Devale
Тема Re: Replication lag
Дата
Msg-id CAB5fag7aCOwDbdjNyGkanANBL_k_GZ=YTc3Pd8NnVBuM7CUckQ@mail.gmail.com
обсуждение исходный текст
Ответ на Replication lag  (Wasim Devale <wasimd60@gmail.com>)
Ответы Re: Replication lag
Re: Replication lag
Список pgsql-admin
Hi All 

Does 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 off
And maximum streaming delay is set to -1

Thanks,
Wasim 

В списке pgsql-admin по дате отправления: