There is a drop in monthly active Lemmy users (from 65k to 57k)
Permanently Deleted
Permanently Deleted
Permanently Deleted
Permanently Deleted
Permanently Deleted
Permanently Deleted
Permanently Deleted
Permanently Deleted
Permanently Deleted
Permanently Deleted
Permanently Deleted
Lemmy Server Performance, PostgreSQL log_min_duration_statement - can big servers share logs? value 2500ms targeting "slow queries"
"Terrence Andrew Davis (December 15, 1969 – August 11, 2018) was an American programmer who created and designed TempleOS, a public domain operating system. Its development was an extremely complex"
I did not realize just the kind of culture and “Rock Star” attitude and really got worked up over a problem someone else encountered
Autism adult, over age 50, and year 2023 economics/inflation/expectations
Non Rhetorical question: Is lemmy.ml the lead developers instance? why did you ignore June 4, 2023 GitHub issue 2910?
How lemmy.ca took on finding why PostgreSQL was at 100% CPU and crashing the Lemmy website this past weekend. PostgreSQL auto_explain
Lemmy Server optimization of PostgreSQL by focusing on community ownership of a post - and visibility of a post in a single control field. Also local flag transition to instance_id field, with value 1
I"m confused where I can get list of moderators for a Community - CommunityModeratorView
Lemmy Server Performance - is this Rust code reading the entire table of all site languages? Does it need to?
Lemmy Server Performance, two birds with one stone, mass deletes of content: Account Delete, Community Delete, User Ban - moving these operations to a linear queue and add undo support / grace period
Lemmy Rust code needs help, Diesel ORM quick change, adding a select field to SiteAggregates::read
Lemmy Server and language choices on every individual comment, many rows in the database per-community, per-site, etc. Overheard of a comment INSERT SQL
Let the servers keep crashing, tell everyone to add new instances to help with performance, which puts 1500 rows into the database tables that used to have 50 rows and invokes a massive federation 1-vote-1-https overhead... causing more crashing... all the while ignoring the SQL design of machine-generated ORM statements and counting logic hidden in the background triggers.
... keep users off your sever as a method of scaling by crashing. It's one of the more interesting experiences I've had this year! And I spent all of February and March with the release of GPT-4... which was also interesting!