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…