Post #3381444
2026-06-23 13:00 UTC
Ugh, I started a database migration on my Smithereen server to add a full-text index to posts. That was around 1 AM. I hoped it would be done in a few hours. It's the middle of the day now and it's still running and only 81% complete.
I really need to figure out how to do these sorts of things without downtime. I also really hope it's the last time I have to add columns to the posts table which contains 2.8 million rows and will only grow over time.
I'm sorry to everyone who uses my server.
Replies (1)
-
@dansup@mastodon.social 2026-06-23 13:03
@grishka@mastodon.social database migrations and fediverse instances, name a more iconic duo! at least you don't have a 264GB statuses table, I want to move comments and boosts to separate tables without breaking existing APIs and causing downtime. it's not fun, but it's part of the job 💪