X-Git-Url: https://git.openstreetmap.org./chef.git/blobdiff_plain/58368b10fb37cfcd56738324f90942a8fd8e3793..682e1fcdcb50f1cf42560a905512487c02dbdcb4:/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 fc9bc7675..ab9ae105b 100644 --- a/cookbooks/db/files/default/monthly-reindex.sql +++ b/cookbooks/db/files/default/monthly-reindex.sql @@ -7,29 +7,29 @@ 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; REINDEX (VERBOSE) TABLE CONCURRENTLY diary_entries; REINDEX (VERBOSE) TABLE CONCURRENTLY diary_entry_subscriptions; REINDEX (VERBOSE) TABLE CONCURRENTLY friends; +REINDEX (VERBOSE) TABLE CONCURRENTLY gpx_files; +REINDEX (VERBOSE) TABLE CONCURRENTLY gpx_file_tags; REINDEX (VERBOSE) TABLE CONCURRENTLY issue_comments; 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; 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;