X-Git-Url: https://git.openstreetmap.org./chef.git/blobdiff_plain/c98b422d89c65d496c3c608130d11fb02c954733..794cc957324de66edab45373053be3e601090f1f:/cookbooks/db/files/default/monthly-reindex.sql

diff --git a/cookbooks/db/files/default/monthly-reindex.sql b/cookbooks/db/files/default/monthly-reindex.sql
index 8a0d1ecbc..ab9ae105b 100644
--- a/cookbooks/db/files/default/monthly-reindex.sql
+++ b/cookbooks/db/files/default/monthly-reindex.sql
@@ -20,6 +20,7 @@ REINDEX (VERBOSE) TABLE CONCURRENTLY issues;
 REINDEX (VERBOSE) TABLE CONCURRENTLY languages;
 REINDEX (VERBOSE) TABLE CONCURRENTLY messages;
 REINDEX (VERBOSE) TABLE CONCURRENTLY note_comments;
+REINDEX (VERBOSE) TABLE CONCURRENTLY note_subscriptions;
 REINDEX (VERBOSE) TABLE CONCURRENTLY notes;
 REINDEX (VERBOSE) TABLE CONCURRENTLY oauth_access_grants;
 REINDEX (VERBOSE) TABLE CONCURRENTLY oauth_access_tokens;