pend my time on Lemmy scrolling “All”, which I think is a pretty common thing.
There was a lot of advice handed out back in June that the answer to scaling Lemmy was to go create instances. The reason it works is because "All" is empty on a virgin system ;) With no data in the database, the logic Lemmy hands to PostgreSQL works real fast ;)
!sdfasdf isn't a community?
Nolan pushed the limit of IMAX projectors with Interstellar run time in 2014, he went out of his way to find out what the maximum that could be done with platter modifications, an extra 20 minutes.
(which created rows of that magnitude for updates does sound like federation messages outbound to me)
rows=1675 from lemmy.ca here: https://github.com/LemmyNet/lemmy/issues/3165#issuecomment-1646673946
It was not about outbound federation messages. It was about counting the number of comments and posts for the sidebar on the right of lemmy-ui to show statistics about the content. site_aggregates is about counting.
The issue isn't who fixed it it, the issue is the lack of testing to find these bugs. It was there for years before anyone noticed it was hammering PostgreSQL on every new comment and post to update data that the code never read back.
There have been multiple data overrun situations, wasting server resources.
I still can't find a call function. I've tried going right at API paths that seem defined, but it gives me a 404 on testing system. It seems the ability to set or clear it on a community is disabled. But I'm not entirely confident in reading the code correctly.
I think 0.18.3 fixed some of it, but there are likely some more performance issues related to PostgreSQL lurking in Lemmy.
A TRIGGER in SQL is a logic that executes based on other activity.
Lemmy uses them so that when you create a new comment or post, it executes code to insert tracking record for votes and comments on a post. One of the things Lemmy does is called site_aggregates, and there was a bug where it was updating the counts for 1500 servers instead of just the one server. That got fixed in 0.18.3
Deleting accounts in lemmy was causes crashes. I'm not sure if that has been entirely resolved. These things are all kind of hidden in the background of the code, so a lot of developers overlooked that there were problems in them.
What’s your goal?
a world where peace, love, and compassion are favored by people and people voluntarily support goodness.
they can do whatever they want with it. Don’t like it, fork it.
It's become clear that what bothers you so much, what you are trying to do is drive off conversation. You care about the machines delivering your content. I actually care that people have self-awareness in the audience of the media they use. Not have blind faith that "fork it" actually is all that matters, and ignore teachers like Marshall McLuhan or Neil Postman who think it is important consumers of media are able to see how their own brain works instead of thinking "fork it" is all that matters, code.
I think audiences could use a website like Wikipedia to do news, instead they favor websites like Reddiit,, Twitter, Lemmy where the main focus is to sort by NEW and get FRESH "breaking news" without accuracy. A rumor mill of rushed information that is often inaccurate or distorted for the purposes of selling adverting/marketing/product placement. I don't think the cost or "fork it" technology of Wikipedia style sites is the problem, I think the issue is audiences have become addicted to and seek out poor-quality information so they can argue about it. A Wikipedia system with edit history and citations would put an end to too many debates and arguments that people seem to seek on rapid "refresh" social media.
I think humanity has gone from the information age to the disinformation age, and I think it is self-destruction, a major war or other self-destruction brewing.
It’s up to the reader to differentiate between facts and tales. I don’t see how that is relevant.
Perhaps you do not see it is relevant, or that you are being insincere on the topic
Humanity track record is to avoid truth and favor mythology. I can suggest Carl Sagan's 1995 book on the subject.
Have you considered turning off your computer, and looking out the window?
Yha, all the people around me are staring into their Smartphones and attacking humanism on social media like you are.
There is neither Twitter nor Facebook out the window.
You apparently can not see them with their Smartphone while driving and doing practically anything.
You quoted it in your reply, but you obviously ignored this: "The constant people I meet in the USA who praise oil consumption and deny climate change science makes me sick."
Meet, in person, IRL, "outside the window" as you call it. You clearly do not care for reality of humanity and what is actually happening because of media like Twitter, Reddit, Lemmy.
GitHub issue about this topic: https://github.com/LemmyNet/lemmy/issues/3782
Some of it might be avoided by tweaking the PostgreSQL database with higher key values after the new install, but the whole situation isn't really planned for or recognized in the code