some queries on standby preventing replication updates

Поиск
Список
Период
Сортировка
От Joe Van Dyk
Тема some queries on standby preventing replication updates
Дата
Msg-id CACfv+pKSoLVMo2+j2GYtGXK-DMbk6_B5hsmny6P_jQbSsSFxaA@mail.gmail.com
обсуждение исходный текст
Ответы Re: some queries on standby preventing replication updates
Список pgsql-general
Hi,

I have a master and a slave database. 

I've got hot_standby_feedback turned on, max_standby_streaming_delay=-1. I've configured the master and slave to keep a few days of WALs around.

I've noticed that when some large queries are run on the standby machine (ones that take more than a minute or so), replication updates are paused. Is there a way to fix this?

Thanks,
Joe

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