Phantasm on Nostr: nprofile1q…37ytg Sun It doesn't help that Pleroma was probably never designed to ...

nprofile1qy2hwumn8ghj7un9d3shjtnddaehgu3wwp6kyqpq0lnelsae3zhv6y3kz8jla2fkwjxrpws0j8vehrv54zg7tfsd3p2sf37ytg (nprofile…7ytg) Sun (nprofile…h6f2) It doesn't help that Pleroma was probably never designed to withstand the traffic it does now. It was meant to be a straightforward AP implementation and the DB reflects that. It doesn't attempt a bunch of normalization of objects
into colums, it shoves the whole object into a jsonb column and calls it a day.

The DB schema is quite performant anyway, the sizes of indexes are the issues usually.