From 68db87bff88a17bc250d072431882ba9f171a7be Mon Sep 17 00:00:00 2001 From: Tom Hughes Date: Wed, 20 Dec 2023 20:11:11 +0000 Subject: [PATCH] Add user_mutes to monthly reindex --- cookbooks/db/files/default/monthly-reindex.sql | 1 + 1 file changed, 1 insertion(+) diff --git a/cookbooks/db/files/default/monthly-reindex.sql b/cookbooks/db/files/default/monthly-reindex.sql index 5ec960715..2789789be 100644 --- a/cookbooks/db/files/default/monthly-reindex.sql +++ b/cookbooks/db/files/default/monthly-reindex.sql @@ -31,6 +31,7 @@ REINDEX (VERBOSE) TABLE CONCURRENTLY redactions; REINDEX (VERBOSE) TABLE CONCURRENTLY reports; REINDEX (VERBOSE) TABLE CONCURRENTLY schema_migrations; REINDEX (VERBOSE) TABLE CONCURRENTLY user_blocks; +REINDEX (VERBOSE) TABLE CONCURRENTLY user_mutes; REINDEX (VERBOSE) TABLE CONCURRENTLY user_preferences; REINDEX (VERBOSE) TABLE CONCURRENTLY user_roles; REINDEX (VERBOSE) TABLE CONCURRENTLY user_tokens; -- 2.39.5