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.

  • Doug
    8·
    4 years ago

    Yeah I can actually browse the website instead of using it as a loading screen simulator

    • 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…