Need a way to concurrently refresh a materialized view
Closed this issue · 1 comments
moveson commented
The .refresh! method executes REFRESH MATERIALIZED VIEW for the subject table. But this command locks the table making it non-queryable during the refresh process.
Since Postgres 9.4, there has been a concurrent refresh option that allows the table to be queried during the refresh. (See https://www.postgresql.org/docs/9.4/sql-refreshmaterializedview.html). It would be good to have a method that accesses this concurrent option. The method might be called .refresh_concurrently!