James Cridland on Nostr: Fiddling with databases. One of my tables is 6.6Gb. Yikes. Just given it a task to ...
Fiddling with databases. One of my tables is 6.6Gb. Yikes. Just given it a task to update a bunch of rows, which pulled my website down for five minutes while it did it. Yay!
Published at
2026-05-13 01:39:23 UTCEvent JSON
{
"id": "360eb097ae74cbd50fddaa98039bb5b017b815c192227b576e9cc1c6a796d160",
"pubkey": "452fa1bb618154a61b5b88d325446577ed6095a21bb29e1049b4acb04d2e61bb",
"created_at": 1778636363,
"kind": 1,
"tags": [
[
"proxy",
"https://bne.social/users/james/statuses/116564712722895964",
"activitypub"
],
[
"client",
"Mostr",
"31990:6be38f8c63df7dbf84db7ec4a6e6fbbd8d19dca3b980efad18585c46f04b26f9:mostr",
"wss://relay.ditto.pub"
]
],
"content": "Fiddling with databases. One of my tables is 6.6Gb. Yikes. Just given it a task to update a bunch of rows, which pulled my website down for five minutes while it did it. Yay!",
"sig": "c4ce851095227747f0555fd40e59c635d2437135a487a565b45fa627b100b9e8469a9fe070b61cf0418d6100b582c87c917e3db10ec3ee6d8a201156b4e0c15b"
}
