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.

  • ConspicuouslyBland@lemmy.ml
    0·
    4 years ago

    When a topic loads, it’s fast indeed. But my visit this evening started with topics not loading at all (kept seeing a circling circle in each of my tabs in which I opened topics). Upon reloading the page, the topics actually loaded.

    I’m running Firefox 77.0.1 on Windows 10

    • inwardpath@lemmy.ml
      0·
      4 years ago

      I also still get this issue. Firefox 78.0.1 on macOS 10.15.5

      For instance, I have opened tabs to both c/buddhism and c/zen and neither one is loading, even after refreshes. Just spinning circle.

      After more testing I think it only happens when opening links to lemmy pages in new tabs. Because in those dead tabs- if I navigate to another link and back, then it works.