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!
moveson
commented
4 years ago
The
.refresh!method executesREFRESH MATERIALIZED VIEWfor 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!