Another fun fact about misskey: some of the defederation logic work by inserting the entire list of blocked instances directly into each individual query. This, of course, kills the Postgres.
#Misskey #ActivityPub #FediDev #Database #Databases #Programming
https://enby.life/files/webpublic-216f8527-8da1-4fa2-9e3b-6fafd12dcf93
Hazelnoot 2 /
npub18s…xdp6g
2024-01-26 04:06:13
Author Public Key
npub18sd0a0d2ajccsuhxgdckth2d95zr2wj6sgmd6px6s5ra8xwlj4ms4xdp6gPublished at
2024-01-26 04:06:13Event JSON
{
"id": "dee15861547c8c0b17f43b4cb1b4166b3923a6c75c1d0130132641d59bb75009",
"pubkey": "3c1afebdaaecb18872e6437165dd4d2d04353a5a8236dd04da8507d399df9577",
"created_at": 1706241973,
"kind": 1,
"tags": [
[
"t",
"misskey"
],
[
"t",
"activitypub"
],
[
"t",
"fedidev"
],
[
"t",
"database"
],
[
"t",
"databases"
],
[
"t",
"programming"
],
[
"proxy",
"https://enby.life/notes/9oxoqaarco",
"activitypub"
]
],
"content": "Another fun fact about misskey: some of the defederation logic work by inserting the entire list of blocked instances directly into each individual query. This, of course, kills the Postgres.\n\n#Misskey #ActivityPub #FediDev #Database #Databases #Programming\n\nhttps://enby.life/files/webpublic-216f8527-8da1-4fa2-9e3b-6fafd12dcf93",
"sig": "284cc5c9861abef2291581709a4605902900500b9236fcb1dc0d55f78e183fbacea664a4c5b99d0e4f4d38e24b429e78b35b0911ddf78cf5175e2495bd052843"
}