Remove temp index tmp_index_for_software_licenses_spdx_identifier_cleanup
Remove temp index tmp_index_for_software_licenses_spdx_identifier_cleanup
created as a part of !114158 (merged)
The index was added to reduce the cleanup migration time and it won't be necessary after that.
Proposed implementation plan
- Create a post-deployment migration as recommended in our Migration Style Guide..
rails g post_deployment_migration DropSoftwareLicensesTempIndex
- Add the following code to new migration
disable_ddl_transaction!
TABLE_NAME = :software_licenses
INDEX_NAME = 'tmp_index_for_software_licenses_spdx_identifier_cleanup'
def up
remove_concurrent_index_by_name(TABLE_NAME, INDEX_NAME)
end
def down
add_concurrent_index TABLE_NAME, :spdx_identifier, where: 'spdx_identifier IS NULL', name: INDEX_NAME
end
Verification steps
-
Access the postgres.ai web interface.
-
Check if the
tmp_index_for_software_licenses_spdx_identifier_cleanup
index was deleted using the command
\d "software_licenses"
Edited by Marcos Rocha