From: Tom Hughes Date: Wed, 20 Dec 2023 20:11:11 +0000 (+0000) Subject: Add user_mutes to monthly reindex X-Git-Url: https://git.openstreetmap.org./chef.git/commitdiff_plain/68db87bff88a17bc250d072431882ba9f171a7be Add user_mutes to monthly reindex --- 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;