Conversation
Notices
-
Embed this notice
@kura @mikoto I am not convinced that the performance problems are because of the json, but the indices do account for the space usage. I don't press the issue because I still haven't figured out what the problem with SPC was entirely.
- Haelwenn /элвэн/ :triskell: likes this.
-
Embed this notice
@kura @sun the other major problem I can tell is that pleroma loves to keep transient activities and other similar things around even if they won't be needed after a short amount of time
-
Embed this notice
@sun @kura add things like edits, deletes, etc and the O2N MVCC model that postgres uses and you can see it can go out of control if you aren't careful
-
Embed this notice
@sun @kura I mean part of the problem with indices is that it makes inserts slower which has been a major problem for me in the past (though it's been better for me after I helped the akkoma project identify and remove unused ones)
but ultimately the problem with storing full json is that there's a lot of redundant data in there which adds up quite quickly