X-Git-Url: https://git.openstreetmap.org./chef.git/blobdiff_plain/1a68a87a1956f3ac4ad538d33569ee29cedef0db..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 65412d414..ab9ae105b 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; @@ -21,12 +20,11 @@ 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;