From 86e057ac95faedb913a83ad3387e7dee6b1d8195 Mon Sep 17 00:00:00 2001 From: Michael Tremer Date: Mon, 19 Feb 2024 15:22:34 +0000 Subject: [PATCH] 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 --- src/backend/blog.py | 2 +- src/backend/wiki.py | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/src/backend/blog.py b/src/backend/blog.py index aed8311b..ff1ff91e 100644 --- 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 9c5f55aa..3698384e 100644 --- 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(""" -- 2.47.2