From 6a59edd9f56fb7bd81cc3cb67032673519a73c17 Mon Sep 17 00:00:00 2001 From: Tom Hughes Date: Sun, 30 Nov 2025 11:06:01 +0000 Subject: [PATCH] Manage the spammy_phrases table in the API database --- cookbooks/db/files/default/monthly-reindex.sql | 1 + cookbooks/db/recipes/master.rb | 2 ++ 2 files changed, 3 insertions(+) diff --git a/cookbooks/db/files/default/monthly-reindex.sql b/cookbooks/db/files/default/monthly-reindex.sql index ffa5faadb..fa8faff76 100644 --- a/cookbooks/db/files/default/monthly-reindex.sql +++ b/cookbooks/db/files/default/monthly-reindex.sql @@ -29,6 +29,7 @@ REINDEX (VERBOSE) TABLE CONCURRENTLY redactions; REINDEX (VERBOSE) TABLE CONCURRENTLY reports; REINDEX (VERBOSE) TABLE CONCURRENTLY schema_migrations; REINDEX (VERBOSE) TABLE CONCURRENTLY social_links; +REINDEX (VERBOSE) TABLE CONCURRENTLY spammy_phrases; REINDEX (VERBOSE) TABLE CONCURRENTLY user_blocks; REINDEX (VERBOSE) TABLE CONCURRENTLY user_mutes; REINDEX (VERBOSE) TABLE CONCURRENTLY user_preferences; diff --git a/cookbooks/db/recipes/master.rb b/cookbooks/db/recipes/master.rb index c56c0557d..eb15a5b67 100644 --- a/cookbooks/db/recipes/master.rb +++ b/cookbooks/db/recipes/master.rb @@ -182,6 +182,7 @@ PROMETHEUS_PERMISSIONS = { reports schema_migrations social_links + spammy_phrases user_blocks user_mutes user_preferences @@ -234,6 +235,7 @@ end redactions_id_seq reports_id_seq social_links_id_seq + spammy_phrases_id_seq user_blocks_id_seq user_mutes_id_seq user_roles_id_seq -- 2.39.5