PERF: Drop index idx_regular_post_search_data concurrently

PERF: Drop index idx_regular_post_search_data concurrently

This can slightly help with the drop command.

That said if a giant vacuum is running we may still time out.

diff --git a/db/post_migrate/20200818084329_update_private_message_on_post_search_data.rb b/db/post_migrate/20200818084329_update_private_message_on_post_search_data.rb
index 6c45b3d..225a4a4 100644
--- a/db/post_migrate/20200818084329_update_private_message_on_post_search_data.rb
+++ b/db/post_migrate/20200818084329_update_private_message_on_post_search_data.rb
@@ -38,7 +38,7 @@ class UpdatePrivateMessageOnPostSearchData < ActiveRecord::Migration[6.0]
     # must drop index cause we do not want an enormous amount of work done
     # as we are changing data
     execute <<~SQL
-     DROP INDEX IF EXISTS idx_regular_post_search_data
+     DROP INDEX CONCURRENTLY IF EXISTS idx_regular_post_search_data
     SQL
 
     # Delete post_search_data of orphaned posts

GitHub sha: 54cf3c67

This commit has been mentioned on Discourse Meta. There might be relevant details there:

https://meta.discourse.org/t/preseeded-categories-which-ones-are-allowed-to-be-altered-or-deleted/161345/2

This commit has been mentioned on Discourse Meta. There might be relevant details there:

https://meta.discourse.org/t/upgrade-failed-error-relation-idx-regular-post-search-data-already-exists/161275/3