On Saturday July 22, 2023… the SysOp of Lemmy.ca got so frustrated with constant overload crashes they cloned their PostgreSQL database and ran AUTO_EXPLAIN on it. They found 1675 rows being written to disk (missive I/O, PostgreSQL WAL activity) for every single UPDATE SQL to a comment/post. They shared details on Github and the PostgreSQL TRIGGER that Lemmy 0.18.2 and earlier had was scrutinized.
Sunday, lemmy.ml is performing better than I have seen it in 60 days. I did get errors on Saturday and significant lag. Not sure if activity is just today or what, but it’s really been fast in routine browsing.
Who are you? I am published author Stephen Alfred Gutknecht, an expert in messaging systems and operating systms. Do you have evidene and facts? (I do have brain damage)
Can you identify who you are?
Can you answer details about GitHub issue 2910 on Lemmy project and the date?
I am sorry to all the never-joined, never-stayed users of Lemmy in May, June, July 2023 “Tweet
is X”, “Reddit is $API” ------ because I could not draw enough attention and developers to Github Issue #2910 avoidance. I failed entirely in my social effort I tried to do for 60+ days. I really failed, brain damaged fuck-up I am. The worst failure in my life, and it’s the end of the line.
Seems content is arriving now