]> git.openstreetmap.org Git - chef.git/blobdiff - cookbooks/db/files/default/monthly-reindex.sql
Tweak energy_perf_bias on odin to squeeze more CPU
[chef.git] / cookbooks / db / files / default / monthly-reindex.sql
index fc9bc7675b123ef1773b00ac4400da1d168a211f..65412d414e3fccd8efa8126b2e7347bebb8fa77b 100644 (file)
@@ -14,6 +14,8 @@ 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;
@@ -29,7 +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;
 REINDEX (VERBOSE) TABLE CONCURRENTLY users;