Home | Notifications | New Note | Local | Federated | Search | Logout
Note Detail
Gregory@grishka@mastodon.social (2026-06-23 22:00:11)
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.
---Reply---
dansup@dansup@mastodon.social (2026-06-23 22:03:49)
@grishka 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 💪
---Attachments---
image: https://files.mastodon.social/media_attachments/files/116/799/551/628/509/578/original/b7910ceaef0ae49a.png
Reply
---Replies---
Gregory@grishka@mastodon.social (2026-06-23 22:07:52)
@dansup wow. Mine is "only" 2.3 GB