I had long suspected my synpase database was missing an index. I had previously checked to confirm that the indexes that synapse creates for some tables I knew are problematic existed. However, figuring out the expected synapse DB schema is quite hard.
Anyway, I've finally used the strong tools and found the missing index and now synapse is suddenly much faster and responsive. Weird how that works.
I think I probably lost that index a couple of database upgrades/migrations ago^^
Martin Giger
npub1a9…5j9xw
2026-06-26 04:44:57 UTC
Author Public Key
npub1a9tl6trsccfsaeyx9rge65truduts23yllmfvh9qw4vxwhcuk3es75j9xwSeen on
wss://relay.ditto.pubPublished at
2026-06-26 04:44:57 UTCEvent JSON
{
"id": "152ed32a0d5065b93ebccd17f65db8c8898e019f513b307216b94f9946fe9e61",
"pubkey": "e957fd2c70c6130ee48628d19d5163e378b82a24fff6965ca07558675f1cb473",
"created_at": 1782449097,
"kind": 1,
"tags": [
[
"proxy",
"https://chaos.social/users/freaktechnik/statuses/116814584055273032",
"activitypub"
],
[
"client",
"Mostr",
"31990:6be38f8c63df7dbf84db7ec4a6e6fbbd8d19dca3b980efad18585c46f04b26f9:mostr",
"wss://relay.ditto.pub"
]
],
"content": "I had long suspected my synpase database was missing an index. I had previously checked to confirm that the indexes that synapse creates for some tables I knew are problematic existed. However, figuring out the expected synapse DB schema is quite hard.\n\nAnyway, I've finally used the strong tools and found the missing index and now synapse is suddenly much faster and responsive. Weird how that works.\n\nI think I probably lost that index a couple of database upgrades/migrations ago^^",
"sig": "fd56d93687764e9e2a9b882fb583bc0af627c21ab1ba09289104ffe0d585c3463884a6af8230f0b17e7ecf057e9ca8a0f6a939cce5b91f30f70646f99f39418e"
}