X-Git-Url: https://git.openstreetmap.org./chef.git/blobdiff_plain/f62e7bd6a79d3ce90c1f1d503f4ff51e4543b27d..3d9c577508cc7d813473e5daa9f236cdd4a676fb:/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 5ec960715..8a0d1ecbc 100644 --- a/cookbooks/db/files/default/monthly-reindex.sql +++ b/cookbooks/db/files/default/monthly-reindex.sql @@ -7,7 +7,6 @@ REINDEX (VERBOSE) TABLE CONCURRENTLY changeset_comments; REINDEX (VERBOSE) TABLE CONCURRENTLY changeset_tags; REINDEX (VERBOSE) TABLE CONCURRENTLY changesets; REINDEX (VERBOSE) TABLE CONCURRENTLY changesets_subscribers; -REINDEX (VERBOSE) TABLE CONCURRENTLY client_applications; REINDEX (VERBOSE) TABLE CONCURRENTLY current_relation_members; REINDEX (VERBOSE) TABLE CONCURRENTLY delayed_jobs; REINDEX (VERBOSE) TABLE CONCURRENTLY diary_comments; @@ -25,13 +24,11 @@ REINDEX (VERBOSE) TABLE CONCURRENTLY notes; REINDEX (VERBOSE) TABLE CONCURRENTLY oauth_access_grants; REINDEX (VERBOSE) TABLE CONCURRENTLY oauth_access_tokens; REINDEX (VERBOSE) TABLE CONCURRENTLY oauth_applications; -REINDEX (VERBOSE) TABLE CONCURRENTLY oauth_nonces; -REINDEX (VERBOSE) TABLE CONCURRENTLY oauth_tokens; 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; REINDEX (VERBOSE) TABLE CONCURRENTLY users;