Refresh materialized view deadlocking?

From: Xiao Ba <bbxiao1(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Refresh materialized view deadlocking?
Date: 2018-07-10 17:53:07
Message-ID: CAO5qf+2NZRv8zXgT0uYC7Bs2ms7ECE6CR1YSiTmOMZGvy8xfjg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Akshaya Acharya 2018-07-10 17:58:36 Re: Refresh materialized view deadlocking?
Previous Message Ravi Krishna 2018-07-10 17:13:53 Re: Disabling/Enabling index before bulk loading