this post was submitted on 08 Aug 2023
57 points (95.2% liked)
Lemmy.world Support
3213 readers
1 users here now
Lemmy.world Support
Welcome to the official Lemmy.world Support community! Post your issues or questions about Lemmy.world here.
This community is for issues related to the Lemmy World instance only. For Lemmy software requests or bug reports, please go to the Lemmy github page.
This community is subject to the rules defined here for lemmy.world.
To open a support ticket
You can also DM https://lemmy.world/u/lwreport or email [email protected] (PGP Supported) if you need to reach our directly to the admin team.
Follow us for server news ๐
Outages ๐ฅ
https://status.lemmy.world
founded 1 year ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
Its a lemmy bug with the backend. The Database breaks down because of some queries and is stuck until a restart.
Do you have the link to the Github issue for that?
No as the admins have to identify the exact troublesome db query themselves.
I dont know if there is any in Postgres
@[email protected] could this help?
I know scaling DBs can be tricky, but I also know there are bootstrap solutions that go pretty high up before needing custom work.
I don't know enough about the lemmy infrastructure, but did they build some custom thing scratch framework or did they start with something stable and tested?
The thing is, it is not the amount available databases. Rather 1 query takes super long and it blocks everything
Its Rust and Postgres
Lemmy uses the Diesel ORM. Lemmy uses a large collection of Rust libraries, so I guess you could say they rolled their own framework. I've never encountered a framework that I believe could handle non-trivial high-traffic web applications. I worked on a project that used Django for years. By the time we were done, we bypassed almost all of Django's functionality to get it to scale with our data and users.