Autumn Sun ☀️🌘☯️ on Nostr: Sat 10:00 UTC - maintenance started Sat 15:06 UTC - launched the task to prune old ...
Sat 10:00 UTC - maintenance started
Sat 15:06 UTC - launched the task to prune old remote objects
Sat 20:55 UTC - idfk man, the last SQL query has been running for over 4.5h already. it seems that it's slowly doing its job, just that the hard drive is choking it a lot. I don't know when we'll be up again but I still have to vacuum tables after this, so it doesn't look that quick
Sat 00:10 UTC - what the hell. going to bed, this better be done in a few hours
Sun 09:21 UTC - one query finished but there's a few more. removing the timer because I have no idea how long this will take but don't get your hopes up, it will run as long as needed. even if it takes a week :-)
Mon 06:00 UTC - I had a dream that the query moved and deleted a few inactive users. alas, still running
Tue 16:33 UTC - the query started... mostly writing to disk instead of reading? I guess that's a good thing
Wed 14:54 UTC - I feel obliged to say that things are going fine :)
The joys of sysadminhood.
nprofile1qy2hwumn8ghj7un9d3shjtnddaehgu3wwp6kyqpqf9ycklvrehw8qn2u00pj6jz9muckdu90r07v30d0pafnylvq2s2s8ty62z (nprofile…y62z)
Published at
2025-04-19 19:34:36Event JSON
{
"id": "b865ecedafcc428a40d28d355bc5be55fccd6a353db95ea784c9bf6afa43ccd0",
"pubkey": "80caa3337d33760ee355697260af0a038ae6a82e6d0b195c7db3c7d02eb394ee",
"created_at": 1745091276,
"kind": 1,
"tags": [
[
"e",
"f6d8868d3aa5ad3013b862f06b917e59379f86c5250341b4d85a3acbb4e69407",
"",
"mention"
],
[
"p",
"7f2933574075f0e8b91cbe1cc4dd79e973665fa6ed1e52e8d559b08dccc9c1ef",
"",
"mention"
],
[
"q",
"f6d8868d3aa5ad3013b862f06b917e59379f86c5250341b4d85a3acbb4e69407"
],
[
"zap",
"7f2933574075f0e8b91cbe1cc4dd79e973665fa6ed1e52e8d559b08dccc9c1ef",
"wss://relay.mostr.pub",
"0.9"
],
[
"zap",
"80caa3337d33760ee355697260af0a038ae6a82e6d0b195c7db3c7d02eb394ee",
"wss://relay.damus.io/",
"0.1"
],
[
"r",
"4.5h"
]
],
"content": "Sat 10:00 UTC - maintenance started\nSat 15:06 UTC - launched the task to prune old remote objects\nSat 20:55 UTC - idfk man, the last SQL query has been running for over 4.5h already. it seems that it's slowly doing its job, just that the hard drive is choking it a lot. I don't know when we'll be up again but I still have to vacuum tables after this, so it doesn't look that quick\nSat 00:10 UTC - what the hell. going to bed, this better be done in a few hours\nSun 09:21 UTC - one query finished but there's a few more. removing the timer because I have no idea how long this will take but don't get your hopes up, it will run as long as needed. even if it takes a week :-)\nMon 06:00 UTC - I had a dream that the query moved and deleted a few inactive users. alas, still running\nTue 16:33 UTC - the query started... mostly writing to disk instead of reading? I guess that's a good thing\nWed 14:54 UTC - I feel obliged to say that things are going fine :)\n\n\nThe joys of sysadminhood.\n\n\n\n\nnostr:nevent1qqs0dkyx35a2ttfszwux9urtj9l9jdulsmzj2q6pknv95wktknnfgpcpzemhxue69uhhyetvv9ujumt0wd68ytnsw43z7q3q0u5nx46qwhcw3wguhcwvfhtea9ekvhaxa50996x4txcgmnxfc8hsxpqqqqqqzjeq87t",
"sig": "b5a4fa5904187ee48e29f36a226ed4595325ed6d1b796785b4de8001049206bbac095fecd3751218bf8b3be8ef0c86391088a4b663be26010a04f152bbd2253f"
}