I didn’t think of using read only replicas, that would probably be a very good way to go since its probably 80%+ of actions are reads. Thanks for answering, I am excited to see the how lemmy grows and thanks for all the devs hard work!

I 100% agree with this and there have been great strides since I started using Lemmy ~v0.17! That said at some point optimization will have lower returns and have a higher effort to put into and once a community grows extensively it likely might not be enough, so I was curious to what you guys were thinking at that point, something like Ctius for sharding postgres?

It is a k8s cluster and using ceph for all of my storage so the latency from that I bet is the largest reason and upping the memory offsets the disk writes. i also have another postgres DB syncing as a fallback for high availability. Fortunately after tuning the database and giving it enough RAM my instance has been running pretty stable for over a year without any changes.

I am also using less powerful computers for the entire infrastructure (not server grade) which brings to the point of having horizontal scaling on database I imagine will be a growing need with growing instances, communities, and users since it can be cheaper to run multiple smaller spec servers rather than a single with the added benefit of high availability.

Yeah I used pgtune as a base and found more memory needed to be assigned to certain spots especially to keep federation with bigger instances, otherwise timeouts would occur resulting in my instance being constantly behind.

That said I read postgres 17 is much more memory efficient, though I have yet to move my lemmy database to it yet since its the largest haha.

On the server perspective, I have a question, what are your thoughts for horizontal scaling on the database? This seems to be the biggest limitation and requiring higher spec hardware to scale especially for the bigger instances.

My tiny instance for example I give over 20GB of RAM just to postgres to make it perform efficient enough.

There is an issue open requesting this… I been following it for a while.

Issue #2631

The steam deck already does limit charging to 80% after being plugged in for an extended period of time so the battery cells will still have a charge but no be in the harmful range.

But that affects the president(s pocket) directly so that is the ONLY thing that will be investigated now probably.

Mine has a remote update functionality that has yet to be used! I think it only is for updated to the screens, anything else needs physical udates, I assume those are firmware upgrades on specific components.

Well he was driving one around without side mirrors… Looking it up apparently dealers are required to in the US, but some places at least may allow no side mirrors if a customer removes them? I can’t believe all states would allow that.

That said when they were first announced and talking about using SpaceX spaceship steel it sounded like it wouldn’t have crumple zones.

Like that we are speedrunning to making Earth into Mars?

I imagine it’d make the business more expensive low orbit satelites slowly fall into the atmosphere and are supposed to burn up after a couple of years. I imagine with lower orbits that they’d fall sooner and you’d have to launch more to sustain your system which then produces more pollution and perpetuates the problem.

Edit article says more space junk and slower burning up in the atmosphere as an effect so that’s interesting. If it becomes a space junk graveyard I imagine satellites will more frequently get damaged by them and become junk themselves?

They are against free school lunches…

Edit fix funny typo

Passkey doesn’t require biometrics necessarily. Password managers are adding support for them, so you can use bitwarden for example which supports password and a security device combo to login and use the passkeys. Passkeys should be more secure than passwords in a password manager since it would only allow using it in the proper domain preventing attacks like opening malicious links in emails or typos when typing a domain manually.

That said a lot of the current approaches to passkeys do use biometric / pin to unlock so you gotta find what’s right for your OPSEC values.

All that said, the article seems pretty bad.

You got 20 years of dailies backlogged! All the FOMO on the seasons!

I always thought of it as something like 2 dimensional beings wouldn’t see 3 dimensional or how we wouldn’t be able to see 4 dimensional beings.

Donate or support an open source engine so we can leave these baddies behind us https://servo.org/ it was originally a mozilla project but is now its own. I have been watching it for a year and they have made a significant amount of progress but still a lot more to go.

Yeah Tesla goes for range and has been caught lying about it being high. That being said Toyotas promise for theirs was Toyota bZ4X Battery To Retain 90% Capacity After 10 Years

If it lines musks profits it could be of interest right now I guess lol. Selling used teslas doesn’t transfer ownership of FSD and stuff so they have to rebuy it, and it could help resell value which buyers put in their decision, so I imagine it could be profitable? That said they are a bunch of idiots so probably not.