It was shared on GitHub on Sunday July 22 by lemmy.ca staff. Developers who run the project do not seem to do merges on Saturday and Sunday. I submitted a pull request Sunday evening given the server crash relief this would provide, ready for them first thing Monday. I clearly labeled the pull request as “emergency”.
It is well into Wednesday and merges are being done on new site features for for the past 3 days. Yet, server crash pull request was edited to remove “emergency” from description first thing Monday and sits without any urgency attention.
This is the same pattern I saw for the past 2 months regarding server crashes related to PostgreSQL.
Previous fixes before the Reddit deadline of end of June were not rushed in to prevent crashes. And this week Elon Musk renaming Twitter to X has been a big influx to the federverse… yet servers are crashing from these SQL UPDATE flaws.
I go by my post yesterday, it’s all some kind of social hazing convention to new users of the Lemmy platform. Lemmy has been around since February 14, 2019 on GitHub. it is not a new app. But the app running on sites since 2019 did not have significant amounts of data (post and comments) until May or June 2023.
I personally feel like I failed because I didn’t understand pg_stat_statements was ignoring stored procedures/functions without an additional parameter. Ooops. Sunday GitHub activity from lemmy.ca staff was my wake-up call on that missing parameter.