this is the part of the Mastodon upgrade process where the load averages spike 😅

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):

a cool thing about Mastodon is that it's literally open source, you can just go poking around and see how it works

a user recently asked me why they couldn't add another reaction to an instance announcement. turns out there's a maximum of eight distinct reactions:

from an educational perspective, it's really useful to have a large, in-production Rails+JS app where anyone can pull down the code

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:

looks like indexing on `null` values takes up database space, so the new indexes ignore nulls, neat!

· · Web · 0 · 0 · 0
Sign in to participate in the conversation
Mastodon for Tech Folks

This Mastodon instance is for people interested in technology. Discussions aren't limited to technology, because tech folks shouldn't be limited to technology either!