Gregory on Nostr: Ugh, I started a database migration on my Smithereen server to add a full-text index ...
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.
Published at
2026-06-23 13:00:11 UTCEvent JSON
{
"id": "c8ef5fc8033264af2d9ee8fe160a77ec591661a791aa809fe3e086613c659be5",
"pubkey": "1af2e9fd1dd57f96297bbd95419cb849041e6ce8b05c6d0c543c7bbf55b81700",
"created_at": 1782219611,
"kind": 1,
"tags": [
[
"proxy",
"https://mastodon.social/@grishka/116799544470860744",
"web"
],
[
"proxy",
"https://mastodon.social/users/grishka/statuses/116799544470860744",
"activitypub"
],
[
"L",
"pink.momostr"
],
[
"l",
"pink.momostr.activitypub:https://mastodon.social/users/grishka/statuses/116799544470860744",
"pink.momostr"
],
[
"-"
]
],
"content": "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.\n\nI 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.\n\nI'm sorry to everyone who uses my server.",
"sig": "4010b4de82b673797475162dfd5cd21c452fc003b6a09397f0bf0667a7f249d01fd4fc6ba3dadcd4d3b884b656607c6b355665cd2a3edefd92ec720cb5c2621d"
}
