RoundSparrow@lemmy.mlBannedM to

Lemmy Server Performance@lemmy.ml · 3 years ago

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

4

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

RoundSparrow@lemmy.mlBannedM to

Lemmy Server Performance@lemmy.ml · 3 years ago

Chat

RoundSparrow@lemmy.mlBannedOPM
link
fedilink
arrow-up
1·
3 years ago
3 hours later… I put it into code and am experimenting with it. Some proof of concept results: https://github.com/LemmyNet/lemmy/files/12373819/auto_explain_list_post_community_0_18_4_dullbananas_with_inclusion_run0a.txt

Lemmy Server Performance@lemmy.ml

lemmyperformance@lemmy.ml

You are not logged in. However you can subscribe from another Fediverse account, for example Lemmy or Mastodon. To do this, paste the following into the search field of your instance: !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.

Visibility: Public

This community can be federated to other instances and be posted/commented in by their users.

1 user / day
1 user / week
1 user / month
1 user / 6 months
2 local subscribers
447 subscribers
43 Posts
113 Comments
Modlog