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": "0fdc66224fbaaee3423b5c12c1681bc38a66b397a0dbb443fa41ae50bef65b4c",
"pubkey": "8e10c71d95b93c41fb37c3ef057b75c43bf22965355da78642065f84df3065d2",
"created_at": 1778636363,
"kind": 1,
"tags": [
[
"proxy",
"https://bne.social/@james/116564712722895964",
"web"
],
[
"proxy",
"https://bne.social/users/james/statuses/116564712722895964",
"activitypub"
],
[
"L",
"pink.momostr"
],
[
"l",
"pink.momostr.activitypub:https://bne.social/users/james/statuses/116564712722895964",
"pink.momostr"
],
[
"-"
]
],
"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": "50e6b8dc37f1c7d1825ce652b1bedd183a3c47c397599ab08630b27c70f8e605438621c0196c70f01eecf679b347c8130eaa8af0291f841341b7d710dd9fd5a2"
}