Re: Refresh materialized view deadlocking?

[Akshaya Acharya <akshaya.acharya.01@xxxxxxxxx>]

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@xxxxxxxxx> 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