who would've thought the majority of performance issues could be fixed with simple database indexes 😅
i never regret choosing mysql for pixelfed.social, I've seen too many horror stories with postgres, like the recent mastodon.cloud migration.
why do people still use postgres??
Daniel Supernault
npub1ln…7737w
2026-09-23 11:23:54 UTC
Author Public Key
npub1ln54yvwdtp88j8cltkthe6kpaahdk0f60g56mfdx27tesdktev0st7737wSeen on
wss://relay.ditto.pubPublished at
2026-09-23 11:23:54 UTCEvent JSON
{
"id": "2d38847046c24fb8bcdb72a52a7506296c3f7363d82f34d66901e67a5c384d97",
"pubkey": "fce95231cd584e791f1f5d977ceac1ef6edb3d3a7a29ada5a657979836cbcb1f",
"created_at": 1790162634,
"kind": 1,
"tags": [
[
"proxy",
"https://mastodon.social/users/dansup/statuses/117320098445921281",
"activitypub"
],
[
"client",
"Mostr",
"31990:6be38f8c63df7dbf84db7ec4a6e6fbbd8d19dca3b980efad18585c46f04b26f9:mostr",
"wss://relay.ditto.pub"
]
],
"content": "who would've thought the majority of performance issues could be fixed with simple database indexes 😅\n\ni never regret choosing mysql for pixelfed.social, I've seen too many horror stories with postgres, like the recent mastodon.cloud migration.\n\nwhy do people still use postgres??",
"sig": "23f616f08a34b2d52348fc8181835dcea6b6222d05abcb0331827b1f8f548b7ce5bc7010214f81845a9b49570c40f95a6af7528cd355ee7e515aca9e7d7a8d3e"
}