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…