Remove materialized views. by dessalines · Pull Request #908 · LemmyNet/lemmy
github.com
external-link

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.

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
edit-2
1Y

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.

Dessalines
mod
creator
1
edit-2
1Y

Okay @theafterman@lemmy.ml @ConspicuouslyBland@lemmy.ml this should be fixed now, v0.7.13. You’ll probably need to refresh the page.

Lemmy Announcements


Feel free to announce new communities here.

Other than that, this is reserved for admin use only.

  • 0 users online
  • 23 users / day
  • 35 users / week
  • 102 users / month
  • 340 users / 6 months
  • 3 subscribers
  • 252 Posts
  • 1184 Comments
  • Modlog