it's great when the Mastodon upgrade notes are like "this update includes long-running migrations"
I was curious about this, since 3.5.2 is just a patch release. what could take so long? in this case, it's adding a single index to the status table (the largest table by large margin): https://github.com/mastodon/mastodon/blob/f17e73da09e6c63665aee4e9731df7808094960e/db/migrate/20220428112511_add_index_statuses_on_account_id.rb#L5
mmm there are also post-deployment migrations which... also add new indexes to the statuses table hmm
or, it's "updating" the index? basically re-creating it in-place with this helper: https://github.com/mastodon/mastodon/blob/f17e73da09e6c63665aee4e9731df7808094960e/lib/mastodon/migration_helpers.rb#L811-L830
looks like indexing on `null` values takes up database space, so the new indexes ignore nulls, neat! https://github.com/mastodon/mastodon/pull/17711