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 <bbxi...@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 >
