Remove materialized views. by dessalines · Pull Request #908 · LemmyNet/lemmy
github.com
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.

  • DessalinesOPMA
    6·
    4 years ago

    Hopefully eventually we can get some more professional DB admins to look ours over, but yeah this one was entirely my fault, I’m awful at DB optimization.

    • ster
      6·
      4 years ago

      Still some improvements to be made, but well done, I don’t have to have other tabs open so I don’t get bored during the loading…