:gcp: is happening on Nostr: 100k dead user rows overnight, instance keeps dying for multiple minutes each time ...
100k dead user rows overnight, instance keeps dying for multiple minutes each time autovacuum locks up
:gcp: is happening /
npub1uv…jteda
2024-05-21 13:32:22
Author Public Key
npub1uvfvlddmhuh4hu4teupjs2lkdn8x3htrrw7jlwzuv0ushumkwnhqxjtedaPublished at
2024-05-21 13:32:22Event JSON
{
"id": "f1208adea92a99d100ee36a1466ab553e46806c019bb06dc3fca0d3e00bb8de1",
"pubkey": "e312cfb5bbbf2f5bf2abcf03282bf66cce68dd631bbd2fb85c63f90bf37674ee",
"created_at": 1716298342,
"kind": 1,
"tags": [
[
"proxy",
"https://declin.eu/objects/c5da8d4e-1190-4d99-a07f-b8e8314fadc3",
"activitypub"
]
],
"content": "100k dead user rows overnight, instance keeps dying for multiple minutes each time autovacuum locks up\n\nhttps://declin.eu/media/567e10207f48cffdfb3e5188f3d6abbcb0d8e63a762a9fbdfc602d030c5b9d17.png\n\nhttps://declin.eu/media/3d0072f6464d218e45e903816ce1ac2c2728cf34ad7fbeb6a7c6b794875b1f6d.png",
"sig": "cfd7aed648ea631baffcb1396cec3adf9bc45076a76b471b81d55c50dab44d51bd4d46ba3573191b56373ea3339f6253b85b90eda1a690d390e45d44736a72cd"
}