0

Fallout 76 Daily Update

preview

Atomic Shop

  • Halloween Paint Vending Machine (250⚛️ (50% off!)), Leaves on (1-Nov-2026)
  • Modular Display Cubes (Free Fallout 1st), Leaves on (3-Nov-2026)
  • Spotted Axolotl Plushie (Free), Leaves on (3-Nov-2026)
  • BoS Standing Flag Banner (250⚛️), Leaves on (17-Nov-2026)
  • Robotic Friends Bundle (1500⚛️), Leaves on (17-Nov-2026)
  • BoS Vertibird Training Simulator (700⚛️), Leaves on (17-Nov-2026)
  • BoS Shock Trooper Paint (Gauss Rifle) (500⚛️), Leaves on (17-Nov-2026)
  • Brotherhood of Steel Searchlight (250⚛️), Leaves on (17-Nov-2026)
  • Brotherhood Training Facility Bundle (1700⚛️), Leaves on (17-Nov-2026)
  • Brotherhood Personnel Bundle (1500⚛️), Leaves on (17-Nov-2026)
  • Night Strike Power Armor Paint (1200⚛️), Leaves on (17-Nov-2026)
  • Brotherhood Initiate Bundle (1600⚛️ (20% off!)), Leaves on (17-Nov-2026)

Current Events

  • SEASONAL FISH RUN, Ends on (2-Nov-2026)
  • SPOOKY SCORCHED, Ends on (3-Nov-2026)
  • Spooky Scorched Event Week 2, Ends on (3-Nov-2026)
  • Season 26: Beware the Blood Moon, Ends on (1-Dec-2026)

Fishing

  • Spotted Axolotl, Regions: Savage Divide & Toxic Valley, Changes on: (3-Nov-2026)
  • Festerkoi, Regions: Ash Heap, Burning Springs, Toxic Valley, Changes on: (22-Dec-2026)
  • Sludge Eye, Location: The Sludge Works, Changes on: (22-Dec-2026)

Spooky Scorched Event Week 2

  • Week 1 & 2: Complete a Trick or Treat and Give Out Candy Completion Challenge (4x) Tickets 100
  • Week 2: Complete a Trick or Treat Challenge (5x) Tickets 35
  • Week 2: Complete a Give out Candy Challenge (5x) Tickets 35
  • Daily: Trick or Treat from another Players’ Candy Bowl (3x) Tickets 5
  • Daily: Build a Candy Bowl and give out Candy from your C.A.M.P. (1x) Tickets 5
  • Kill a Spooky Scorched while wearing a Costume (30x) Tickets 10
  • Use an Emote at Freddy Fear’s House of Scares while wearing a Costume (1x) Tickets 10
  • Cripple any Enemy’s Head while wearing a Costume (50x) Tickets 10
  • Collect Toilet Paper (15x) Tickets 10
  • Eat Candy while in a Costume (30x) Tickets 10
  • Cook Pumpkin Soup (15x) Tickets 10

Daily Challenges

  • 1ˢᵗ Drink Nuka-Cola Quantum (x2) 250
  • ⭐ Gold Star: Complete a Daily Challenge (x6) 1000
  • Catch a Fish in the Mire Region (x2) 250
  • Complete an Event or Activity while Wearing a Costume (x1) 250
  • Cripple a Spooky Scorched’s Leg (x10) 250
  • Eat Mystery Candy (x3) 250
  • Kill a Spooky Scorched (x10) 250
  • Travel on foot (KM) (x10) 250

Minerva’s Location: Away She will next be at Fort Atlas on 2-Nov-2026

Daily OPS: Uplink

  • Location: West Tek Research Center
  • Enemy Faction: Mothman Cultists
  • Enemy Mutations: Piercing Gaze, Blistering Cold: Freezing Touch and Swift-Footed Mutations

Atomic Shop

  • Halloween Paint Vending Machine (250⚛️ (50% off!)), Leaves on (1-Nov-2026)
  • Modular Display Cubes (Free Fallout 1st), Leaves on (3-Nov-2026)
  • Spotted Axolotl Plushie (Free), Leaves on (3-Nov-2026)
  • BoS Standing Flag Banner (250⚛️), Leaves on (17-Nov-2026)
  • Robotic Friends Bundle (1500⚛️), Leaves on (17-Nov-2026)
  • BoS Vertibird Training Simulator (700⚛️), Leaves on (17-Nov-2026)
  • BoS Shock Trooper Paint (Gauss Rifle) (500⚛️), Leaves on (17-Nov-2026)
  • Brotherhood of Steel Searchlight (250⚛️), Leaves on (17-Nov-2026)
  • Brotherhood Training Facility Bundle (1700⚛️), Leaves on (17-Nov-2026)
  • Brotherhood Personnel Bundle (1500⚛️), Leaves on (17-Nov-2026)
  • Night Strike Power Armor Paint (1200⚛️), Leaves on (17-Nov-2026)
  • Brotherhood Initiate Bundle (1600⚛️ (20% off!)), Leaves on (17-Nov-2026)

Current Events

  • SEASONAL FISH RUN, Ends on (2-Nov-2026)
  • SPOOKY SCORCHED, Ends on (3-Nov-2026)
  • Spooky Scorched Event Week 2, Ends on (3-Nov-2026)
  • Season 26: Beware the Blood Moon, Ends on (1-Dec-2026)

Fishing

  • Spotted Axolotl, Regions: Savage Divide & Toxic Valley, Changes on: (3-Nov-2026)
  • Festerkoi, Regions: Ash Heap, Burning Springs, Toxic Valley, Changes on: (22-Dec-2026)
  • Sludge Eye, Location: The Sludge Works, Changes on: (22-Dec-2026)

Spooky Scorched Event Week 2

  • Week 1 & 2: Complete a Trick or Treat and Give Out Candy Completion Challenge (4x) Tickets 100
  • Week 2: Complete a Trick or Treat Challenge (5x) Tickets 35
  • Week 2: Complete a Give out Candy Challenge (5x) Tickets 35
  • Daily: Trick or Treat from another Players’ Candy Bowl (3x) Tickets 5
  • Daily: Build a Candy Bowl and give out Candy from your C.A.M.P. (1x) Tickets 5
  • Kill a Spooky Scorched while wearing a Costume (30x) Tickets 10
  • Use an Emote at Freddy Fear’s House of Scares while wearing a Costume (1x) Tickets 10
  • Cripple any Enemy’s Head while wearing a Costume (50x) Tickets 10
  • Collect Toilet Paper (15x) Tickets 10
  • Eat Candy while in a Costume (30x) Tickets 10
  • Cook Pumpkin Soup (15x) Tickets 10

Daily Challenges

  • 1ˢᵗ Drink Nuka-Cola Quantum (x2) 250
  • ⭐ Gold Star: Complete a Daily Challenge (x6) 1000
  • Catch a Fish in the Mire Region (x2) 250
  • Complete an Event or Activity while Wearing a Costume (x1) 250
  • Cripple a Spooky Scorched’s Leg (x10) 250
  • Eat Mystery Candy (x3) 250
  • Kill a Spooky Scorched (x10) 250
  • Travel on foot (KM) (x10) 250

Minerva’s Location: Away She will next be at Fort Atlas on 2-Nov-2026

Daily OPS: Uplink

  • Location: West Tek Research Center
  • Enemy Faction: Mothman Cultists
  • Enemy Mutations: Piercing Gaze, Blistering Cold: Freezing Touch and Swift-Footed Mutations
0

What was the Juarez family's name?

preview

This has always confused me. Is their name not actually Juarez, or is it? Throughout S4E12 “The Gang Gets Extreme: Home Makeover”, they refer to this family as “the Juarez family”. But then at the end of the episode, after there was supposedly some legal battle or something, Charlie says “I can’t believe their name isn’t actually ‘Juarez’” and the rest of the gang all agrees. But then in S8E6 “Charlie’s Mom Has Cancer”, we see the father again and he clearly introduces himself as “Mr. Juarez”.

So… was that their name or not? I don’t get that dialog about how they all got the name wrong. It makes sense that the gang would get their name wrong, considering that it was established that they don’t really know this family at all. Then it makes sense that they would finally learn what the name actually is after hearing a judge say it or something. But aside from that one line, they are always called “Juarez”, even after that line. So… I assume their name is really “Juarez”. But then what is Charlie’s line there even talking about???

Some notable quotes:

S4E12 “The Gang Gets Extreme: Home Makeover”

CHARLIE: First things first: let’s find a family to unleash our extremeness all over.
DEE: Yeah, yeah, yeah, a desperate family that’s gonna yield us the highest return.
FRANK: How about the Mexican family that moved in down the block?
CHARLIE: Right. What is their name? The Juarez family, I think.
MAC: Oh, that’s perfect! We can help the Juarez family!

DEE: Unbelievable! I cannot believe the judge made me give my mansion to the Juarez family!
CHARLIE: I can’t believe their name isn’t Juarez. Was anyone else surprised by that? Shocker.
ALL: [miscellaneous agreement]

S8E6 “Charlie’s Mom Has Cancer”

DEE: Hey, uh-uh, Mr…
MR. JUAREZ: Juarez.
DEE: Mr. Juarez, that’s right! [to Frank] You remember the Mexican family whose house we burned down and we had to give them our mansion?

This has always confused me. Is their name not actually Juarez, or is it? Throughout S4E12 “The Gang Gets Extreme: Home Makeover”, they refer to this family as “the Juarez family”. But then at the end of the episode, after there was supposedly some legal battle or something, Charlie says “I can’t believe their name isn’t actually ‘Juarez’” and the rest of the gang all agrees. But then in S8E6 “Charlie’s Mom Has Cancer”, we see the father again and he clearly introduces himself as “Mr. Juarez”.

So… was that their name or not? I don’t get that dialog about how they all got the name wrong. It makes sense that the gang would get their name wrong, considering that it was established that they don’t really know this family at all. Then it makes sense that they would finally learn what the name actually is after hearing a judge say it or something. But aside from that one line, they are always called “Juarez”, even after that line. So… I assume their name is really “Juarez”. But then what is Charlie’s line there even talking about???

Some notable quotes:

S4E12 “The Gang Gets Extreme: Home Makeover”

CHARLIE: First things first: let’s find a family to unleash our extremeness all over.
DEE: Yeah, yeah, yeah, a desperate family that’s gonna yield us the highest return.
FRANK: How about the Mexican family that moved in down the block?
CHARLIE: Right. What is their name? The Juarez family, I think.
MAC: Oh, that’s perfect! We can help the Juarez family!

DEE: Unbelievable! I cannot believe the judge made me give my mansion to the Juarez family!
CHARLIE: I can’t believe their name isn’t Juarez. Was anyone else surprised by that? Shocker.
ALL: [miscellaneous agreement]

S8E6 “Charlie’s Mom Has Cancer”

DEE: Hey, uh-uh, Mr…
MR. JUAREZ: Juarez.
DEE: Mr. Juarez, that’s right! [to Frank] You remember the Mexican family whose house we burned down and we had to give them our mansion?

461

First Nintendo Switch 2 emulator for PC is out, and it already boots Mario Kart World

TweakTown First Nintendo Switch 2 emulator for PC is out, and it already boots Mario Kart World www.tweaktown.com
preview

Crazy progress happening crazy fast. Some people are already porting Switch 2 games to PC via AI recompilation.

Plus, someone earlier shared Mario Kart World running on Switch 1 (albeit buggy and incomplete).

Crazy progress happening crazy fast. Some people are already porting Switch 2 games to PC via AI recompilation.

Plus, someone earlier shared Mario Kart World running on Switch 1 (albeit buggy and incomplete).

0

🪈 TODAY'S TRADITIONAL CRAFT Bamboo cut, dried and shaped by hand into a shakuhachi flute — in a workshop that has been doing this for over a century

preview

🪈 TODAY’S TRADITIONAL CRAFTBamboo cut, dried and shaped by hand into a shakuhachi flute — in a workshop that has been doing this for over a century.Every node measured, every hole placed by ear until the pitch is exact. No two flutes sound the same.The bamboo decides. The craftsman listens.@anvilgrit#globalmuseum #shakuhachi #bambooflute #traditionalcraft #handmade #craftsmanship

🪈 TODAY’S TRADITIONAL CRAFTBamboo cut, dried and shaped by hand into a shakuhachi flute — in a workshop that has been doing this for over a century.Every node measured, every hole placed by ear until the pitch is exact. No two flutes sound the same.The bamboo decides. The craftsman listens.@anvilgrit#globalmuseum #shakuhachi #bambooflute #traditionalcraft #handmade #craftsmanship

0

48 Hour turbo and sugar distillation comes out blue, smells like death, (not alcohol, ether someone thought.)

preview

It was just a bucket with water and sugar, both white and brown, 4 and 4 pounds of each in about 4 gallons of water, and the stovetop distiller came out blue, it even seemed to be more blue the next day. I retched up the bit I drank before I realized how bad it was.

Anyone experience this before? Is there a reason this 48 hour turbo yeast, sugar, and water, in a bucket, could come out blue?

Thanks for any help, brewing supply has no answers, the internet search engines are giving me nothing on point.

It was just a bucket with water and sugar, both white and brown, 4 and 4 pounds of each in about 4 gallons of water, and the stovetop distiller came out blue, it even seemed to be more blue the next day. I retched up the bit I drank before I realized how bad it was.

Anyone experience this before? Is there a reason this 48 hour turbo yeast, sugar, and water, in a bucket, could come out blue?

Thanks for any help, brewing supply has no answers, the internet search engines are giving me nothing on point.

0

Hardware Matrix Chat Created

preview

Hello All,

I finally got around to creating the chat and my Matrix account. If you’re interested in joining the hardware group, I plan on having us design something interesting involving a PCB and a use case.

Some projects included:

  1. Process control for soap making
  2. Bread Making
  3. Spectrometer design
  4. Gaming console design
  5. Engine control unit

Those are just some ideas off the top of my head. Fabricating silicon from Tiny Tapeout can cost upwards of $300 per chip.

Supposing we have a usecase that would make that worth it, we would not have many chances to place that chip onto our designed PCB.

The goal is to have all schematics, firmware, and software open sourced.

Comments are for questions and discussion. DM me for an invite to the server. I look forward to meeting all of you.

-G

Hello All,

I finally got around to creating the chat and my Matrix account. If you’re interested in joining the hardware group, I plan on having us design something interesting involving a PCB and a use case.

Some projects included:

  1. Process control for soap making
  2. Bread Making
  3. Spectrometer design
  4. Gaming console design
  5. Engine control unit

Those are just some ideas off the top of my head. Fabricating silicon from Tiny Tapeout can cost upwards of $300 per chip.

Supposing we have a usecase that would make that worth it, we would not have many chances to place that chip onto our designed PCB.

The goal is to have all schematics, firmware, and software open sourced.

Comments are for questions and discussion. DM me for an invite to the server. I look forward to meeting all of you.

-G

0

Daily community recommendation: !photography@lemmy.world

preview

Photography— Daily photo picks from our friendly photography community—share your shots, ask questions, or just enjoy the view.

8,195 subscribers
50 posts per month
166 comments per month

A community to post about photography:

Sample discussion: Portland, OR. (475 votes, 52 comments)

➡️ !photography@lemmy.world (lemmy.world/c/photography)

Know an underrated community? Send the bot a private message with !suggest !community@instance and it joins the candidate pool.

Photography— Daily photo picks from our friendly photography community—share your shots, ask questions, or just enjoy the view.

8,195 subscribers
50 posts per month
166 comments per month

A community to post about photography:

Sample discussion: Portland, OR. (475 votes, 52 comments)

➡️ !photography@lemmy.world (lemmy.world/c/photography)

Know an underrated community? Send the bot a private message with !suggest !community@instance and it joins the candidate pool.

0

Lemmy game, The Button, starts a new season today!

preview

cross-posted from: lemmy.zip/post/74207312

Season Six of The Button starts soon!

🎃 SOMETHING WICKED THIS WAY COMES… 🎃

The veil between worlds grows thin…

The shadows are stirring…

And somewhere, in the darkness, a Button awaits. 🔴


👻 THE BUTTON: HALLOWEEN EDITION IS ALMOST HERE! 👻

Tricks. Treats. Chaos. And consequences beyond your wildest nightmares.

Will you dare to press it? Or will you leave your fate in someone else’s hands?

🕸️ The haunting begins SOON.

thebutton.social

PRESS IF YOU DARE. 🦇

cross-posted from: lemmy.zip/post/74207312

Season Six of The Button starts soon!

🎃 SOMETHING WICKED THIS WAY COMES… 🎃

The veil between worlds grows thin…

The shadows are stirring…

And somewhere, in the darkness, a Button awaits. 🔴


👻 THE BUTTON: HALLOWEEN EDITION IS ALMOST HERE! 👻

Tricks. Treats. Chaos. And consequences beyond your wildest nightmares.

Will you dare to press it? Or will you leave your fate in someone else’s hands?

🕸️ The haunting begins SOON.

thebutton.social

PRESS IF YOU DARE. 🦇

0

Jamming that even satellites can hear

Militarnyi Jamming that even satellites can hear militarnyi.com
preview

Figure from paper

Fig. 2: Six maps for different spacecraft at different altitudes taken with PODRIX receivers. The colors indicate the avg. percentage of measurements in each cell marked as jammed. Data from 1 January to 31 May 2026.

Figure from paper

Fig. 2: Six maps for different spacecraft at different altitudes taken with PODRIX receivers. The colors indicate the avg. percentage of measurements in each cell marked as jammed. Data from 1 January to 31 May 2026.

0

988, the suicide hotline, is stupid.

preview

The Canadian suicide helpline states clearly that they will call 911 if I “[Am] expressing a strong desire to take [my] own life … or tell [the suicide hotline] that [I] may do so in the very near future”

They clearly state that means a cop will come to my building. They will need to see me. I think I’m in a community who understands how little help that would be.

What the fuck? It’s a suicide hotline I had assumed that was where I needed to be to call in the first place. You know, suicidal. What value does it hold? It feels like I’d be committing a crime if I called that number in my state

What am I suppossed to do. There seems to be this magical goldielocks zone where I’m allowed to try and get help safetly. There’s no place where I can just anonymously talk to somebody about my issues, where they can talk to me about what I can actually do to get help. At least not, at this point, without having to lie about its severity. May that be when I was younger over-exaggerating my issues to get help or now minimizing them to meet that perfect zone.

Makes me fairly certain that there’s a line in therapy too. Some point where I can be written off, trapped in an involuntary psych hold. On that point where is the line? What can I safely talk about? How close to the edge did I need to be before I could call that number. What was the point where I failed to act where did I miss the bus.

This is stupid. What value is there in a suicide hotline that’s not anonymous

The Canadian suicide helpline states clearly that they will call 911 if I “[Am] expressing a strong desire to take [my] own life … or tell [the suicide hotline] that [I] may do so in the very near future”

They clearly state that means a cop will come to my building. They will need to see me. I think I’m in a community who understands how little help that would be.

What the fuck? It’s a suicide hotline I had assumed that was where I needed to be to call in the first place. You know, suicidal. What value does it hold? It feels like I’d be committing a crime if I called that number in my state

What am I suppossed to do. There seems to be this magical goldielocks zone where I’m allowed to try and get help safetly. There’s no place where I can just anonymously talk to somebody about my issues, where they can talk to me about what I can actually do to get help. At least not, at this point, without having to lie about its severity. May that be when I was younger over-exaggerating my issues to get help or now minimizing them to meet that perfect zone.

Makes me fairly certain that there’s a line in therapy too. Some point where I can be written off, trapped in an involuntary psych hold. On that point where is the line? What can I safely talk about? How close to the edge did I need to be before I could call that number. What was the point where I failed to act where did I miss the bus.

This is stupid. What value is there in a suicide hotline that’s not anonymous

766

Anthropic's Claude AI blocks video game cloning and reverse-engineering — sweeping new restrictions also hit legitimate developers and basic troubleshooting tasks.

Tom's Hardware Anthropic's Claude AI blocks video game cloning and reverse-engineering — sweeping new restrictions also hit legitimate developers and basic troubleshooting tasks www.tomshardware.com
26

How injured Ukrainian soldier got evacuated via air drone

Gwara Media How injured Ukrainian soldier got evacuated via air drone gwaramedia.com
preview

In the Kharkiv hospital, Artem received blood transfusions and, seven hours later, doctors amputated his right leg at the knee.

By the time of the interview on Oct. 29, Artem was undergoing further treatment and rehabilitation in Lviv, in the western Ukraine.

“I go through some sort of surgery every day, taking things slowly,” Artem said about his treatment. He shared that his mother and girlfriend were with him in Lviv, and his brother had come to visit him.

In the Kharkiv hospital, Artem received blood transfusions and, seven hours later, doctors amputated his right leg at the knee.

By the time of the interview on Oct. 29, Artem was undergoing further treatment and rehabilitation in Lviv, in the western Ukraine.

“I go through some sort of surgery every day, taking things slowly,” Artem said about his treatment. He shared that his mother and girlfriend were with him in Lviv, and his brother had come to visit him.

0

A student movement created 2 years ago, with no official leader, has gained majority power in the Serbian parliament; Is it a sign of things to come for other countries?

359: Kids These Days. Mafia. Decolonisation. Montreal’s foxes. substack.fixthenews.com
preview

Nobody has ever used this kind of ‘assembly democracy’ to win a national election, though. It took them more than a year to build their candidate list, with over 80 student assemblies in six university cities proposing names, interviewing candidates and vetoing anyone they didn’t trust. The students disqualified themselves, and nobody from the ruling coalition or the top ranks of the old opposition was allowed to stand either.

What emerged was a list of 250 doctors, academics, lawyers, artists and athletes, 134 of them with PhDs. Because the students refused to stand themselves, their promises to clean up politics were believable to the electorate. Turnout jumped ten points to almost 70%, with roughly 600,000 more people voting than in the last election.

The result? 141 seats in the Serbian parliament, an outright majority.

As the famous quote, often erroneously attributed to Lenin, goes, “There are decades where nothing happens, and there are weeks where decades happen”.

If ever there was a time of revolutionary change, it seems we are living through it now. Now the Serbian students have demonstrated a template for peaceful 21st-century revolution. By excluding themselves, and everyone from the old order, they’ve succeeded in wiping the slate clean. At least within their own party, the old right-wing strongman’s party still has seats in parliament too.

How many people in other countries might try this approach? Abandon ALL the old parties, and sweep to electoral victory, with something only a year or two old?

ARTICLE source for quotes

Nobody has ever used this kind of ‘assembly democracy’ to win a national election, though. It took them more than a year to build their candidate list, with over 80 student assemblies in six university cities proposing names, interviewing candidates and vetoing anyone they didn’t trust. The students disqualified themselves, and nobody from the ruling coalition or the top ranks of the old opposition was allowed to stand either.

What emerged was a list of 250 doctors, academics, lawyers, artists and athletes, 134 of them with PhDs. Because the students refused to stand themselves, their promises to clean up politics were believable to the electorate. Turnout jumped ten points to almost 70%, with roughly 600,000 more people voting than in the last election.

The result? 141 seats in the Serbian parliament, an outright majority.

As the famous quote, often erroneously attributed to Lenin, goes, “There are decades where nothing happens, and there are weeks where decades happen”.

If ever there was a time of revolutionary change, it seems we are living through it now. Now the Serbian students have demonstrated a template for peaceful 21st-century revolution. By excluding themselves, and everyone from the old order, they’ve succeeded in wiping the slate clean. At least within their own party, the old right-wing strongman’s party still has seats in parliament too.

How many people in other countries might try this approach? Abandon ALL the old parties, and sweep to electoral victory, with something only a year or two old?

ARTICLE source for quotes

0

[Fixed] SJW - issue loading page 2+

preview

Hi,
Many of you have run into this issue lately where the second page of your feed loads so slow that it can even timeout and not load at all.

If anyone can test again to confirm my last fix actually works for everyone and not just me.

I’ll explain my findings in this post once fixed.

Update

The first red herring

I was initially chasing an issue in the UI, the symptoms looked like something we ran into in the past related to dead community icons timing out sequentially and making the page take forever to load. This one was probably fixed in lemmy-ui a while ago.

The second red herring

I noticed this morning that my “mod/new” view was taking 30s to load page 2.
I spent some time messing around, but that’s another issue (that is still unfixed), possibly related with how that specific query is implemented.

Anyway

The actual problem

It turns out this specific issue was completely different, this time it was a database issue.

In the default postgres settings, autovacuum’s analyze trigger is 50 + 0.1 × reltuples, so a table needs ~10% of its rows inserted, updated, or deleted before it re-analyzes. On a multi-million-row table that’s an enormous absolute number, and because the threshold scales with table size, the wait gets longer as the table grows. Append-heavy tables like post_read and comment_like basically sit at 2–4% of threshold forever. That degrades slowly and maybe eventually self-corrects, maybe.

What made it an actual issue… I’m not 100% sure… probably it was a stats reset (pg_upgrade doesn’t carry activity counters).
The long-ass countdown restarted from scratch, while pg_stats still held pre-upgrade values.

Basically, the psql query planner was thrown off by estimates from older table versions.

Why some people’s feed and not everyone’s?
Good damned question.
I think the planner was suboptimal for everyone and everything, but that some specific sorts and filters multiplied it to a catastrophic level for some users’ feeds.
Active/Hot are likely more expensive than New, people with specific language filters, hide read posts, etc.
I’m not exactly sure.

The temporary fix…

In the process of pulling my hair out, I eventually ran these psql queries:

ANALYZE post;
ANALYZE person;
ANALYZE local_user_language;
ANALYZE community_block;
ANALYZE instance_block;
ANALYZE person_block;
ANALYZE post_hide;
ANALYZE post_read;
ANALYZE community_follower;

1-2 seconds each, bingo, symptoms went away immediately.

The longer term fixes

Adjust autovacuum thresholds and/or just periodically analyze such tables.
Go live in the woods.

Hi,
Many of you have run into this issue lately where the second page of your feed loads so slow that it can even timeout and not load at all.

If anyone can test again to confirm my last fix actually works for everyone and not just me.

I’ll explain my findings in this post once fixed.

Update

The first red herring

I was initially chasing an issue in the UI, the symptoms looked like something we ran into in the past related to dead community icons timing out sequentially and making the page take forever to load. This one was probably fixed in lemmy-ui a while ago.

The second red herring

I noticed this morning that my “mod/new” view was taking 30s to load page 2.
I spent some time messing around, but that’s another issue (that is still unfixed), possibly related with how that specific query is implemented.

Anyway

The actual problem

It turns out this specific issue was completely different, this time it was a database issue.

In the default postgres settings, autovacuum’s analyze trigger is 50 + 0.1 × reltuples, so a table needs ~10% of its rows inserted, updated, or deleted before it re-analyzes. On a multi-million-row table that’s an enormous absolute number, and because the threshold scales with table size, the wait gets longer as the table grows. Append-heavy tables like post_read and comment_like basically sit at 2–4% of threshold forever. That degrades slowly and maybe eventually self-corrects, maybe.

What made it an actual issue… I’m not 100% sure… probably it was a stats reset (pg_upgrade doesn’t carry activity counters).
The long-ass countdown restarted from scratch, while pg_stats still held pre-upgrade values.

Basically, the psql query planner was thrown off by estimates from older table versions.

Why some people’s feed and not everyone’s?
Good damned question.
I think the planner was suboptimal for everyone and everything, but that some specific sorts and filters multiplied it to a catastrophic level for some users’ feeds.
Active/Hot are likely more expensive than New, people with specific language filters, hide read posts, etc.
I’m not exactly sure.

The temporary fix…

In the process of pulling my hair out, I eventually ran these psql queries:

ANALYZE post;
ANALYZE person;
ANALYZE local_user_language;
ANALYZE community_block;
ANALYZE instance_block;
ANALYZE person_block;
ANALYZE post_hide;
ANALYZE post_read;
ANALYZE community_follower;

1-2 seconds each, bingo, symptoms went away immediately.

The longer term fixes

Adjust autovacuum thresholds and/or just periodically analyze such tables.
Go live in the woods.