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 | |
| 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.
| -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 b9faf180d8a..bc9011113f7 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 9b2a284e497..56c0b4cb0af 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 |