Refresh materialized view deadlocking?
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
Hi Xiao
From
https://www.postgresql.org/docs/current/static/sql-refreshmaterializedview.html
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:
Show quoted text
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