Merge remote-tracking branch 'github/pull/686'

[chef.git] / 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 fc9bc7675b123ef1773b00ac4400da1d168a211f..8a0d1ecbce7203558b4150bf1aaa75f358251e97 100644 (file)
--- a/cookbooks/db/files/default/monthly-reindex.sql
+++ b/cookbooks/db/files/default/monthly-reindex.sql
@@ -7,13 +7,14 @@ 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 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 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 issue_comments;
 REINDEX (VERBOSE) TABLE CONCURRENTLY issues;
 REINDEX (VERBOSE) TABLE CONCURRENTLY languages;


@@ -23,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_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 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_preferences;
 REINDEX (VERBOSE) TABLE CONCURRENTLY user_roles;

-REINDEX (VERBOSE) TABLE CONCURRENTLY user_tokens;

 REINDEX (VERBOSE) TABLE CONCURRENTLY users;
 REINDEX (VERBOSE) TABLE CONCURRENTLY users;