19Lemmy server admins, please enable pg_stat_statements on your PostgreSQL server so the Lemmy community can better identify the performance problems on the more active sites c/lemmyperformance · by RoundSparrow@lemmy.ml · 3y · 15 comments
9Redis, Memcached, dragonfly for Lemmy and 2010 presentation on scaling.... c/lemmyperformance · by RoundSparrow@lemm.ee · 2y · 3 comments
4post inclusion, a solid WHERE clause filter before any JOIN on SELECT post (listing of posts) c/lemmyperformance · by RoundSparrow@lemmy.ml · 2y · 20 comments
5lemmy Server Performance backwards from PostgreSQL data to Rust code and TRIGGER FUNCTION logic, listed observations c/lemmyperformance · by RoundSparrow@bulletintree.com · 2y · 0 comments
1Lemmy Server Performance, PostgreSQL log_min_duration_statement - can big servers share logs? value 2500ms targeting "slow queries" c/lemmyperformance · by RoundSparrow@lemmy.ml · 3y · 0 comments
1Code to Stress Test Lemmy for performance c/lemmyperformance · by RoundSparrow@lemmy.ml · 3y · 1 comments
24How lemmy.ca took on finding why PostgreSQL was at 100% CPU and crashing the Lemmy website this past weekend. PostgreSQL auto_explain c/lemmyperformance · by RoundSparrow@lemmy.ml · 3y · 3 comments
2Lemmy 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 c/lemmyperformance · by RoundSparrow@lemmy.ml · 3y · 4 comments
2Lemmy Server Performance - is this Rust code reading the entire table of all site languages? Does it need to? c/lemmyperformance · by RoundSparrow@lemmy.ml · 3y · 0 comments
7Lemmy 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 c/lemmyperformance · by RoundSparrow@lemmy.ml · 3y · 7 comments
5Lemmy Server and language choices on every individual comment, many rows in the database per-community, per-site, etc. Overheard of a comment INSERT SQL c/lemmyperformance · by RoundSparrow@lemmy.ml · 3y · 8 comments
7REQUEST community review of Lemmy Server Performance on Post Votes, Comment Votes - the most frequent database writes. Optimize? c/lemmyperformance · by RoundSparrow@lemmy.ml · 3y · 2 comments
231GREAT 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 c/lemmyperformance · by RoundSparrow@lemmy.ml · 3y · 27 comments
11Information Overload - Beehaw style beehaw.orgc/lemmyperformance · by Penguincoder@beehaw.org · 3y · 0 comments
8Lemmy scaling/performance: Move expensive PostgreSQL triggers to scheduled jobs. · GitHub Issue #3528 · LemmyNet/lemmy github.comc/lemmyperformance · by RoundSparrow@lemmy.ml · 3y · 2 comments
7Information Overload - Beehaw style - Beehaw beehaw.orgc/lemmyperformance · by RoundSparrow@lemmy.ml · 3y · 0 comments
9lemmy_server Rust code now exposes internal metrics via Prometheus endpoint github.comc/lemmyperformance · by RoundSparrow@lemmy.ml · 3y · 1 comments
157Big 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.worldc/lemmyperformance · by RoundSparrow@lemmy.ml · 3y · 7 comments
4lemmy PERFORMANCE CRISIS: Rust code in pull requests is starting to use moka caching crate c/lemmyperformance · by RoundSparrow@lemmy.ml · 3y · 5 comments
