RoundSparrow@lemmy.mlM · edit-21 year agoLemmy 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 sitesplus-squarepinmessage-squaremessage-square11fedilinkarrow-up118arrow-down11
arrow-up117arrow-down1message-squareLemmy 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 sitesplus-squarepinRoundSparrow@lemmy.mlM · edit-21 year agomessage-square11fedilink
RoundSparrow @ .ee@lemm.ee · 10 months agoRedis, Memcached, dragonfly for Lemmy and 2010 presentation on scaling....plus-squaremessage-squaremessage-square3fedilinkarrow-up18arrow-down10
arrow-up18arrow-down1message-squareRedis, Memcached, dragonfly for Lemmy and 2010 presentation on scaling....plus-squareRoundSparrow @ .ee@lemm.ee · 10 months agomessage-square3fedilink
RoundSparrow@lemmy.mlM · 10 months agopost inclusion, a solid WHERE clause filter before any JOIN on SELECT post (listing of posts)message-squaremessage-square20fedilinkarrow-up14arrow-down10
arrow-up14arrow-down1message-squarepost inclusion, a solid WHERE clause filter before any JOIN on SELECT post (listing of posts)RoundSparrow@lemmy.mlM · 10 months agomessage-square20fedilink
RoundSparrow @ BT@bulletintree.comM · 11 months agolemmy Server Performance backwards from PostgreSQL data to Rust code and TRIGGER FUNCTION logic, listed observationsplus-squaremessage-squaremessage-square0fedilinkarrow-up16arrow-down11
arrow-up15arrow-down1message-squarelemmy Server Performance backwards from PostgreSQL data to Rust code and TRIGGER FUNCTION logic, listed observationsplus-squareRoundSparrow @ BT@bulletintree.comM · 11 months agomessage-square0fedilink
RoundSparrow@lemmy.mlM · edit-211 months agoLemmy Server Performance, PostgreSQL log_min_duration_statement - can big servers share logs? value 2500ms targeting "slow queries"plus-squaremessage-squaremessage-square1fedilinkarrow-up14arrow-down10
arrow-up14arrow-down1message-squareLemmy Server Performance, PostgreSQL log_min_duration_statement - can big servers share logs? value 2500ms targeting "slow queries"plus-squareRoundSparrow@lemmy.mlM · edit-211 months agomessage-square1fedilink
RoundSparrow@lemmy.mlM · edit-211 months agoCode to Stress Test Lemmy for performanceplus-squaremessage-squaremessage-square10fedilinkarrow-up112arrow-down11
arrow-up111arrow-down1message-squareCode to Stress Test Lemmy for performanceplus-squareRoundSparrow@lemmy.mlM · edit-211 months agomessage-square10fedilink
RoundSparrow@lemmy.mlM · edit-211 months agoHow lemmy.ca took on finding why PostgreSQL was at 100% CPU and crashing the Lemmy website this past weekend. PostgreSQL auto_explainplus-squaremessage-squaremessage-square8fedilinkarrow-up113arrow-down10
arrow-up113arrow-down1message-squareHow lemmy.ca took on finding why PostgreSQL was at 100% CPU and crashing the Lemmy website this past weekend. PostgreSQL auto_explainplus-squareRoundSparrow@lemmy.mlM · edit-211 months agomessage-square8fedilink
RoundSparrow@lemmy.mlM · 11 months agoLemmy 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 1plus-squaremessage-squaremessage-square3fedilinkarrow-up12arrow-down10
arrow-up12arrow-down1message-squareLemmy 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 1plus-squareRoundSparrow@lemmy.mlM · 11 months agomessage-square3fedilink
RoundSparrow@lemmy.mlM · edit-211 months agoLemmy Server Performance - is this Rust code reading the entire table of all site languages? Does it need to?plus-squaremessage-squaremessage-square1fedilinkarrow-up17arrow-down11
arrow-up16arrow-down1message-squareLemmy Server Performance - is this Rust code reading the entire table of all site languages? Does it need to?plus-squareRoundSparrow@lemmy.mlM · edit-211 months agomessage-square1fedilink
RoundSparrow@lemmy.mlM · edit-211 months agoLemmy 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 periodplus-squaremessage-squaremessage-square8fedilinkarrow-up114arrow-down10
arrow-up114arrow-down1message-squareLemmy 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 periodplus-squareRoundSparrow@lemmy.mlM · edit-211 months agomessage-square8fedilink
RoundSparrow@lemmy.mlM · edit-211 months agoLemmy Server and language choices on every individual comment, many rows in the database per-community, per-site, etc. Overheard of a comment INSERT SQLplus-squaremessage-squaremessage-square5fedilinkarrow-up16arrow-down11
arrow-up15arrow-down1message-squareLemmy Server and language choices on every individual comment, many rows in the database per-community, per-site, etc. Overheard of a comment INSERT SQLplus-squareRoundSparrow@lemmy.mlM · edit-211 months agomessage-square5fedilink
RoundSparrow@lemmy.mlM · edit-211 months agoREQUEST community review of Lemmy Server Performance on Post Votes, Comment Votes - the most frequent database writes. Optimize?plus-squaremessage-squaremessage-square2fedilinkarrow-up15arrow-down10
arrow-up15arrow-down1message-squareREQUEST community review of Lemmy Server Performance on Post Votes, Comment Votes - the most frequent database writes. Optimize?plus-squareRoundSparrow@lemmy.mlM · edit-211 months agomessage-square2fedilink
RoundSparrow@lemmy.mlM · edit-211 months agoGREAT 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 tableplus-squaremessage-squaremessage-square32fedilinkarrow-up1242arrow-down12
arrow-up1240arrow-down1message-squareGREAT 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 tableplus-squareRoundSparrow@lemmy.mlM · edit-211 months agomessage-square32fedilink
RoundSparrow@lemmy.mlM · 1 year agoLemmy scaling/performance: Move expensive PostgreSQL triggers to scheduled jobs. · GitHub Issue #3528 · LemmyNet/lemmyplus-squaregithub.comexternal-linkmessage-square2fedilinkarrow-up18arrow-down10
arrow-up18arrow-down1external-linkLemmy scaling/performance: Move expensive PostgreSQL triggers to scheduled jobs. · GitHub Issue #3528 · LemmyNet/lemmyplus-squaregithub.comRoundSparrow@lemmy.mlM · 1 year agomessage-square2fedilink
RoundSparrow@lemmy.mlM · 1 year agoInformation Overload - Beehaw style - Beehawbeehaw.orgexternal-linkmessage-square0fedilinkarrow-up18arrow-down10cross-posted to: [email protected]
arrow-up18arrow-down1external-linkInformation Overload - Beehaw style - Beehawbeehaw.orgRoundSparrow@lemmy.mlM · 1 year agomessage-square0fedilinkcross-posted to: [email protected]
RoundSparrow@lemmy.mlM · 1 year agolemmy_server Rust code now exposes internal metrics via Prometheus endpointplus-squaregithub.comexternal-linkmessage-square1fedilinkarrow-up18arrow-down10
arrow-up18arrow-down1external-linklemmy_server Rust code now exposes internal metrics via Prometheus endpointplus-squaregithub.comRoundSparrow@lemmy.mlM · 1 year agomessage-square1fedilink
RoundSparrow@lemmy.mlM · edit-21 year agoBig 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!plus-squarelemmy.worldexternal-linkmessage-square7fedilinkarrow-up1145arrow-down12
arrow-up1143arrow-down1external-linkBig 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!plus-squarelemmy.worldRoundSparrow@lemmy.mlM · edit-21 year agomessage-square7fedilink
DreadTowel@lemmy.worldEnglish · 1 year agoDe-facto memory leakplus-squaremessage-squaremessage-square11fedilinkarrow-up126arrow-down10
arrow-up126arrow-down1message-squareDe-facto memory leakplus-squareDreadTowel@lemmy.worldEnglish · 1 year agomessage-square11fedilink
RoundSparrow@lemmy.mlM · 1 year agolemmy PERFORMANCE CRISIS: Rust code in pull requests is starting to use moka caching crateplus-squaremessage-squaremessage-square5fedilinkarrow-up14arrow-down10
arrow-up14arrow-down1message-squarelemmy PERFORMANCE CRISIS: Rust code in pull requests is starting to use moka caching crateplus-squareRoundSparrow@lemmy.mlM · 1 year agomessage-square5fedilink
