DessalinesMA to

Announcements · 4 years ago

We've deployed some fixes to our database, Lemmy should be a lot faster now. v0.7.12

122

We've deployed some fixes to our database, Lemmy should be a lot faster now. v0.7.12

DessalinesMA to

Announcements · 4 years ago

Remove materialized views. by dessalines · Pull Request #908 · LemmyNet/lemmy

I wrote up a big thing on this, and then my computer crashed :( so here's the short version. Read speeds: ☭ ./generate_explain_reports.sh comment_fast_view.json: "Execution Time...

Credit to @eiknat@dev.lemmy.ml , and masterstur for their help with this effort.

Our postgres CPU usage has gone wayyyy down.

Chat

DessalinesOPMA
link
fedilink
arrow-up
4·
4 years ago
It was my scheme all along :smirking face:

Announcements

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: !announcements@lemmy.ml

Community locked: only moderators can create posts. You can still comment on posts.

Official announcements from the Lemmy project. Subscribe to this community or add it to your RSS reader in order to be notified about new releases and important updates.

You can also find major news on join-lemmy.org

Visibility: Public

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

1 user / day
96 users / week
243 users / month
779 users / 6 months
19K local subscribers
23.3K subscribers
410 Posts
5.36K Comments
Modlog