My federated timeline retrieves only one page of recent active posts when sorted by Hot, but the next page of posts it retrieves are dead and several months old. The “Bumblebee on sage” post in the screenshot was posted 1 hour ago but the post right after it “Cats Distinguish Between Speech” was posted 7 months ago. The rest of the posts were posted 2 months ago or more and have no upvotes. Is this an issue with my instance only or do other instances also have this bug?

  • @PriorProject@lemmy.worldEnglish
    2•1 year ago

    Hot ranking was identified as a problematically slow query in https://github.com/LemmyNet/lemmy/issues/2877. Maybe it’s possible that it’s timing out on the postgres backend and you’re getting partial results.

    I see you’re a fellow lemmy.world user, you could crosspost to !lemmworld@lemmy.world and possibly at-mention Ruud or one of the new admins listed in https://lemmy.world/post/28012 to see if they anything funky going on in the logs.

    My prediction is that there’s nothing you can do about this personally, though, other than report it to admins and provide any information they request.

    • AndreasOPEnglish
      1•1 year ago

      Thanks! This makes a lot of sense. I only see this problem with hot ranking so I had a feeling it was related to the database query. I’ll avoid using hot ranking until the query is optimized.