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
REQUEST community review of Lemmy Server Performance on Post Votes, Comment Votes - the most frequent database writes. Optimize?
Lemmy convention for linking individual posts and comments include the username of post/comment creator, giving people credit in the URL itself
GREAT NEWS about Lemmy Server Performance, another major SQL mistake has been discovered today: every single comment & post create (INSERT) is updating ~1700 rows in the site_aggregates table
« Personne ne se rend compte que certaines personnes dépensent une force herculéenne pour être seulement normales. »
Lemmy scaling/performance: Move expensive PostgreSQL triggers to scheduled jobs. · GitHub Issue #3528 · LemmyNet/lemmy
lemmy_server Rust code now exposes internal metrics via Prometheus endpoint
Big Lemmy server lemmy.world has put into production critical performance fixes from a runaway SQL query identified by analyzing pg_stat_statements output - and greatly reduced their server overload!
lemmy PERFORMANCE CRISIS: Rust code in pull requests is starting to use moka caching crate