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

theafterman
link
fedilink
arrow-up
4·
4 years ago
I can definitely notice the improvement. I tested it in Firefox 68 ESR on my PC and Firefox Nightly on my mobile. Great work again, and quick too.
- DessalinesOPMA
  link
  fedilink
  arrow-up
  2·
  4 years ago
  Ya this was a pretty bad bug.
  - theafterman
    link
    fedilink
    arrow-up
    3·
    4 years ago
    Was it #801?
    - DessalinesOPMA
      link
      fedilink
      arrow-up
      3·
      4 years ago
      Yep.

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
2 users / week
199 users / month
563 users / 6 months
19K local subscribers
23.4K subscribers
412 Posts
5.38K Comments
Modlog