Refresh materialized view deadlocking?

Поиск
Список
Период
Сортировка
От Xiao Ba
Тема Refresh materialized view deadlocking?
Дата
Msg-id CAO5qf+2NZRv8zXgT0uYC7Bs2ms7ECE6CR1YSiTmOMZGvy8xfjg@mail.gmail.com
обсуждение исходный текст
Ответы Re: Refresh materialized view deadlocking?
Список pgsql-general
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 по дате отправления:

Предыдущее
От: Ravi Krishna
Дата:
Сообщение: Re: Disabling/Enabling index before bulk loading
Следующее
От: Akshaya Acharya
Дата:
Сообщение: Re: Refresh materialized view deadlocking?