Re: Refresh materialized view deadlocking?

Поиск
Список
Период
Сортировка
От Akshaya Acharya
Тема Re: Refresh materialized view deadlocking?
Дата
Msg-id CABPa3Q515JKSn028S_GoyuRrnZF335umbcMDtSVbQNAcy2nv3w@mail.gmail.com
обсуждение исходный текст
Ответ на Refresh materialized view deadlocking?  (Xiao Ba <bbxiao1@gmail.com>)
Список pgsql-general
Hi Xiao


For concurrently option
" Even with this option only one REFRESH at a time may run against any one materialized view. "

I would guess yes.

Regards, Akshaya

On Tue, 10 Jul 2018 at 23:24, Xiao Ba <bbxiao1@gmail.com> wrote:
I have a materialized view that gets refreshed concurrently every 10 seconds (b/c it contains time sensitive stuff). At times it appears to get backed up so there are multiple refreshes queued and then gets stuck waiting for a lock? Does anybody know if this is expected behavior? Am I supposed to be manually managing to ensure that only one refresh is being requested at a time?

Thanks,
Xiao

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

Предыдущее
От: Xiao Ba
Дата:
Сообщение: Refresh materialized view deadlocking?
Следующее
От: Patrick Hemmer
Дата:
Сообщение: max_standby_streaming_delay not enforced