about summary refs log tree commit diff
path: root/db
diff options
context:
space:
mode:
authorClaire <claire.github-309c@sitedethib.com>2021-05-07 18:14:29 +0200
committerGitHub <noreply@github.com>2021-05-07 18:14:29 +0200
commitd8e0c8a89e1f1dd1c4ce1513deaeb3c85c6e4a42 (patch)
tree8b3440ccc20e597b7949bcdd01b02bb151f110bf /db
parenta5f91a11d07db93526597131100c919f21a5dd78 (diff)
Do not populate AccountSummaries and FollowRecommendation views on migration (#16173)
Materializing those views can take a while, and they are currently refreshed
anyway each time they are actually used, in the FollowRecommendationsScheduler.
Diffstat (limited to 'db')
-rw-r--r--db/migrate/20210322164601_create_account_summaries.rb2
-rw-r--r--db/migrate/20210505174616_update_follow_recommendations_to_version_2.rb2
2 files changed, 2 insertions, 2 deletions
diff --git a/db/migrate/20210322164601_create_account_summaries.rb b/db/migrate/20210322164601_create_account_summaries.rb
index b9faf180d..bc9011113 100644
--- a/db/migrate/20210322164601_create_account_summaries.rb
+++ b/db/migrate/20210322164601_create_account_summaries.rb
@@ -1,6 +1,6 @@
 class CreateAccountSummaries < ActiveRecord::Migration[5.2]
   def change
-    create_view :account_summaries, materialized: true
+    create_view :account_summaries, materialized: { no_data: true }
 
     # To be able to refresh the view concurrently,
     # at least one unique index is required
diff --git a/db/migrate/20210505174616_update_follow_recommendations_to_version_2.rb b/db/migrate/20210505174616_update_follow_recommendations_to_version_2.rb
index 9b2a284e4..56c0b4cb0 100644
--- a/db/migrate/20210505174616_update_follow_recommendations_to_version_2.rb
+++ b/db/migrate/20210505174616_update_follow_recommendations_to_version_2.rb
@@ -4,7 +4,7 @@ class UpdateFollowRecommendationsToVersion2 < ActiveRecord::Migration[6.1]
 
   def up
     drop_view :follow_recommendations
-    create_view :follow_recommendations, version: 2, materialized: true
+    create_view :follow_recommendations, version: 2, materialized: { no_data: true }
 
     # To be able to refresh the view concurrently,
     # at least one unique index is required