RocketDerp

@dessalines "We are in desperate need of SQL experts, as my SQL skills are very mediocre. We'd love to have your expertise." Is there any kind of documentation that describes...

I advise that all Lemmy servers enable PG extension [pg_stat_statements](https://www.postgresql.org/docs/current/pgstatstatements.html) to debug slow SQL statements. This way logging does not have to be cranked up. Lemmy discussion and some example...

post_aggregates has no index on community_id, and I saw a big improvement with PostgreSQL 15.3 on my live data by adding an index. https://github.com/LemmyNet/lemmy/pull/3839 ``` INNER JOIN community ON (...

I am finally able to reproduce incredibly slow queries on routine listing of posts with my own generated test data! I'm running against latest main checkout.  Given the two...

Ok, here are the full EXPLAIN ANALYZE for the exact same community, no variation in community data between the two queries. One takes over 14 full seconds, the other takes...

I ran scripts/test.sh and that was the only test to fail test_should_not_validate_user_token_after_password_change - reran scripts/test.sh - and it passed. A couple more runs, a fail. So it still seems flaky.

I also observe that the instances don't seem to have a "Error Landing Page" to send the end-user to when they run into an internal site error. It just seems...

> Take this post for example: https://slrpnk.net/post/433623 > > This is a post by a remote user, in a remote community, yet the image is clearly served from my domain....

For the past week, the front page of lemmy.ml has had very fast response with nginx 500 and 404 invalid JSON errors. I've seen it also on Beehaw, but less...

Why do already-running sites have their /setup URL available? Even when not logged-in? https://lemmy.ml/setup