database: Refresh any materialized views concurrently

When we dump the database we cannot run this operation which causes the
webapp to lock up.

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

diff --git a/src/backend/blog.py b/src/backend/blog.py
index aed8311b1c40edfc87108180759e5d8733c998a0..ff1ff91e32591888bf7ca85663503bb9bc8880b1 100644 (file)
--- a/src/backend/blog.py
+++ b/src/backend/blog.py
@@ -139,7 +139,7 @@ class Blog(misc.Object):
                        Needs to be called after a post has been changed
                        and updates the search index.
                """
-               self.db.execute("REFRESH MATERIALIZED VIEW blog_search_index")
+               self.db.execute("REFRESH MATERIALIZED VIEW CONCURRENTLY blog_search_index")
 
        @property
        def years(self):

diff --git a/src/backend/wiki.py b/src/backend/wiki.py
index 9c5f55aa72180a4e09676209a3a470e993c58f8a..3698384ed07dc2c5d326f5cb4b41b1fd4ae49ca3 100644 (file)
--- a/src/backend/wiki.py
+++ b/src/backend/wiki.py
@@ -206,7 +206,7 @@ class Wiki(misc.Object):
                """
                        Needs to be called after a page has been changed
                """
-               self.db.execute("REFRESH MATERIALIZED VIEW wiki_search_index")
+               self.db.execute("REFRESH MATERIALIZED VIEW CONCURRENTLY wiki_search_index")
 
        def get_watchlist(self, account):
                pages = self._get_pages("""