Lemmy Server Performance

!lemmyperformance@lemmy.ml

Established1 year ago

Sort:

Active Scaled Hot New TopAll TopYear TopMonth TopWeek TopDay

1

Lemmy 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

posted 1 year ago

*

by

RoundSparrow@lemmy.mlM

0 commentshide report

1

Redis, Memcached, dragonfly for Lemmy and 2010 presentation on scaling....

posted 1 year ago

by

RoundSparrow @ .ee@lemm.ee

0 commentshide report

1

post inclusion, a solid WHERE clause filter before any JOIN on SELECT post (listing of posts)

posted 1 year ago

by

RoundSparrow@lemmy.mlM

0 commentshide report

1

lemmy Server Performance backwards from PostgreSQL data to Rust code and TRIGGER FUNCTION logic, listed observations

posted 1 year ago

by

RoundSparrow @ BT@bulletintree.comM

0 commentshide report

1

Lemmy Server Performance, PostgreSQL log_min_duration_statement - can big servers share logs? value 2500ms targeting "slow queries"

posted 1 year ago

*

by

RoundSparrow@lemmy.mlM

0 commentshide report

1

Code to Stress Test Lemmy for performance

posted 1 year ago

*

by

RoundSparrow@lemmy.mlM

0 commentshide report

1

How lemmy.ca took on finding why PostgreSQL was at 100% CPU and crashing the Lemmy website this past weekend. PostgreSQL auto_explain

posted 1 year ago

*

by

RoundSparrow@lemmy.mlM

0 commentshide report

1

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

posted 1 year ago

by

RoundSparrow@lemmy.mlM

0 commentshide report

1

Lemmy Server Performance - is this Rust code reading the entire table of all site languages? Does it need to?

posted 1 year ago

*

by

RoundSparrow@lemmy.mlM

0 commentshide report

1

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

posted 1 year ago

*

by

RoundSparrow@lemmy.mlM

0 commentshide report

1

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

posted 1 year ago

*

by

RoundSparrow@lemmy.mlM

0 commentshide report

1

REQUEST community review of Lemmy Server Performance on Post Votes, Comment Votes - the most frequent database writes. Optimize?

posted 1 year ago

*

by

RoundSparrow@lemmy.mlM

0 commentshide report

1

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

posted 1 year ago

*

by

RoundSparrow@lemmy.mlM

0 commentshide report

1

Lemmy scaling/performance: Move expensive PostgreSQL triggers to scheduled jobs. · GitHub Issue #3528 · LemmyNet/lemmy(github.com)

posted 1 year ago

by

RoundSparrow@lemmy.mlM

0 commentshide report

1

Information Overload - Beehaw style - Beehaw(beehaw.org)

posted 1 year ago

by

RoundSparrow@lemmy.mlM

0 commentshide report

1

lemmy_server Rust code now exposes internal metrics via Prometheus endpoint(github.com)

posted 1 year ago

by

RoundSparrow@lemmy.mlM

0 commentshide report

1

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.world)

posted 1 year ago

*

by

RoundSparrow@lemmy.mlM

0 commentshide report

1

De-facto memory leak

posted 1 year ago

by

DreadTowel@lemmy.world

0 commentshide report

1

lemmy PERFORMANCE CRISIS: Rust code in pull requests is starting to use moka caching crate

posted 1 year ago

by

RoundSparrow@lemmy.mlM

0 commentshide report

1

Lemmy PERFORMANCE CRISIS: popular instances with many remote instances following big communities could stop federating outbound for Votes on comments/posts - code path identified

posted 1 year ago

*

by

RoundSparrow@lemmy.mlM

0 commentshide report

1

PERFORMANCE OPTIMIZATION: lemmy_server Rust code all over database lookup: "= LocalSite::read"

posted 1 year ago

*

by

RoundSparrow@lemmy.mlM

0 commentshide report

1

lemmy.world feedback is that 0.17.4 performs better than 0.18.1 - is this true? What is slower?

posted 1 year ago

by

RoundSparrow@lemmy.mlM

0 commentshide report

1

lemmy_server API for Clients and Federation alike, concurrency self-awareness, load sheding, and self-tuning

posted 1 year ago

by

RoundSparrow@lemmy.mlM

0 commentshide report

1

lemmy-ui seems to be doing database search for Post Title matches while typing every single character or edit, for performance reasons suggest an option to disable this feature be available to admins

posted 1 year ago

*

by

RoundSparrow@lemmy.mlM

0 commentshide report

1

Add http cache for webfingers by cetra3 · Pull Request #3317 · LemmyNet/lemmy (adding moka as an in-memory cache to Rust code)(github.com)

posted 1 year ago

*

by

RoundSparrow@lemmy.mlM

0 commentshide report

Lemmy Server Performance

!lemmyperformance@lemmy.ml

Lemmy Server Performance

lemmy_server uses the Diesel ORM that automatically generates SQL statements. There are serious performance problems in June and July 2023 preventing Lemmy from scaling. Topics include caching, PostgreSQL extensions for troubleshooting, Client/Server Code/SQL Data/server operator apps/sever operator API (performance and storage monitoring), etc.

Community stats

6
Monthly active users
41
Posts
0
Comments

Community moderators

Lemmy

What is Lemmy.ml

Rules

No bigotry - including racism, sexism, ableism, homophobia, transphobia, or xenophobia. Code of Conduct.
Be respectful, especially when disagreeing. Everyone should feel welcome here.
No porn.
No Ads / Spamming.

Feel free to ask questions over in: