I bought Diablo 1 in 1997 for 50 or 60 CAD.
It was well worth it at the time even though that's probably $100+ now with inflation.
Games are probably one of the things that resisted inflation the most.

My problem with most AAA games today is they simply don't grab my interest as much.

I'd gladly pay 200 bucks to rediscover something like Planescape: Torment for the first time, but I can't be bothered to even acknowledge the existence of Assassin's Creed 31 or Skyrim 42.
GTA? idk, never been my cup of tea, but might be worth it to someone who enjoyed the previous ones.

Almost realized their problem is expecting higher talent at lowballed prices.

184
submitted 2 weeks ago* (last edited 2 weeks ago) by InEnduringGrowStrong@sh.itjust.works to c/main@sh.itjust.works

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.

198
[-] InEnduringGrowStrong@sh.itjust.works 154 points 11 months ago

I like chunkier scrollbars. Fuck the tiny disappearing scrollbars where you need to mouse over... somewhere.. to maybe be graced with its presence, only for it to be 1px wide for some reason.
Also fuck the endless scroll, especially when you already know what you're looking for is on page 4 because you had to reload the page for some reason but the infinite scroll didn't save your position and you have to go down (without an actual scrollbar) only to "load more" 3 times until you're (maybe) on page 4.

And then all of them are "Nicole".

52

You'd think with all the cereals we're producing, it'd be ubiquitous, but all the stuff at the grocery store was either Kelloggs, Kraft, or General Mills.
I think Shreddies are made in Canada, but owned by Post?

There seemsto be a few more options out west than here in QC.
I already get granola from a small local place which is great, but surely there's a Canadian version of corn flakes or rice krispies or whatnot somewhere.

I'm also open to just making my own.

Dear Mr. Daniel,
I'm sorry that a store pulling things from their shelves is hurting your business, but I thought you should know that this is not even the tip of the iceberg.
Regardless of what any store does, I will simply not be buying Jack Daniel's, probably ever, along with a slew of other things, as many as I possibly can.

There are so many better whiskeys around the world that I certainly don't need to.
I empathize with the collateral damage this may cause, and hope that something, anything really, is eventually enough for y'all fuckers to start thinking about getting your shit together.
In the meantime, I will simply Buy Anything But American.

I am just one person, but I am not alone.
Sincerely,
Fix your shit or get fucked,
A random Canadian

2
Slight Detour (lemmy.blahaj.zone)

Multi track parking mate

Québec has gotten rid of the royal oath requirement, surely Yukon can think of something.

1

Demon cores aren't literal.

95
A-10 Wartshark (sh.itjust.works)

To celebrate making up with our sharky friends

publication croisée depuis : https://sh.itjust.works/post/27606331

🦈 💌


Source: https://www.digitalcombatsimulator.com/en/files/3331315/

Credits to user Floptical

82

an 8-year-old girl and an 11-year-old boy are among the dead.

Great way to radicalize the next generation.

You'd think so, but no.
Short story is the 'nominal' size is the size before going into a planer to smooth the faces.
Yes, it makes little sense, like many things related to construction stuff.

38
1
Test (sh.itjust.works)

This was already budgeted for when they decided to use a chatbot instead of paying employees to do that job.
Trying to blame the bot is just lame.

6
submitted 2 years ago* (last edited 2 years ago) by InEnduringGrowStrong@sh.itjust.works to c/pixeldungeon@lemmy.world

It's my little ritual, just in case there's ever an alternate ending where you rid the world of the amulet instead.

Toss it in the pits/volcano kinda vibe.

What useless stuff do you try on your runs?

61

Tell us what game you are currently, or recently played, greater than 6+ months old.

If the game happens to be on sale, a link would be a plus.

2
it's love (i.redd.it)

So I recently had a conversation with some who though Linus Torvalds (kernel) and Linus Sebastian (Linus Tech Tips) was the same person.
That was a pretty funny and confusing conversation.

If ads weren't riddled with malware or absolutely obnoxious...
Browsing without an ad blocker is cancer

view more: next ›

InEnduringGrowStrong

0 post score
0 comment score
joined 3 years ago
MODERATOR OF