diff options
author | Claire <claire.github-309c@sitedethib.com> | 2021-05-07 18:14:29 +0200 |
---|---|---|
committer | GitHub <noreply@github.com> | 2021-05-07 18:14:29 +0200 |
commit | d8e0c8a89e1f1dd1c4ce1513deaeb3c85c6e4a42 (patch) | |
tree | 8b3440ccc20e597b7949bcdd01b02bb151f110bf /db | |
parent | a5f91a11d07db93526597131100c919f21a5dd78 (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.rb | 2 | ||||
-rw-r--r-- | db/migrate/20210505174616_update_follow_recommendations_to_version_2.rb | 2 |
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 |