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
---Replies---
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
Gregory@grishka@mastodon.social (2026-06-23 22:05:11)
Oh actually. Here's the fun part. Queries on that table still work as it's being altered. I should've just been doing this manually and asynchronously...
---Attachments---
image: https://files.mastodon.social/media_attachments/files/116/799/563/389/358/740/original/2ea811be563e034d.png