Self Proclaimed Internet user and Administrator of Reddthat
Oh I was wrong, after further reading this looks to be a lot better than what I was thinking.
I must have been thinking about another methodology of attempted privacy over a dataset.
Before I start reading, if this has anything to do with differential privacy, I’m going to be disappointed.
2nd best reporting in.
A faster db. Just the regular performance benefits, https://www.postgresql.org/about/news/postgresql-16-released-2715/
Also, Lemmy is built against v16 (now) so at some point it will eventually no longer JustWork
The script will be useless to you, besides for referencing what to do.
Export, remove pg15, install pg16, import. I think you can streamline with both installed at once as they correctly version. You could also use the in place upgrade. Aptly named: pg_upgradeclusters
But updating to 0.19.4, you do not need to go to pg16… but… you should, because of the benefits!
Congratulations! 👏 Happy B-day and here’s to many more to my across the river friends 🎉
Ps. The video works and is great!
The downvotes you can see (on this post) are from accounts on your instance then. As this post is semi inflammatory it is highly likely to have garnered some downvotes.
Edit: I guess I was wrong regarding the logic of how downvotes work when we block them. As the http request (used too?) return an error when responding to a downvote. I’ll have to look at it again. As the only way it was/is 15, is if:
That awkward moment when you are the person they are talking about when running beta in production!
Bug:
subscribe & unsubscribe links are the wrong sizes on communities?listingType=Local
“Bug”:
Your IP is visibleto
Suggestions:
Sent from next.reddthat.com :)
Right? Such a good vibe.
Glad you could find an intermediate home! Your community is always welcome back if needed.
Since the 11th @ 9am UTC, LW has seen a 2 fold increase of activities. If my insider knowledge is right (and math) it’s 7req/s average up from 3req/s.
Lucky for both of us we are not subbed to every community on LW but I think we are subbed just enough to be affected.
Relevant: https://reddthat.com/comment/8316861 tl;dr. The current centralisation results in a lemmy-verse theoretical maximum for of 1 activity per 0.3 seconds, or 200 activities per minute. As total transfer of packets is just under 0.3 seconds between EU -> AU and back.
Edit: can’t math when sleepy
Should be already fixed. I’ve logged out and in on Jerboa.
We rebuilt the Lemmy container with an extra logging patch. Seems build docs need some work? as that’s the only difference in the past 1-2 days, except for moving to postgres 16…
Thanks for the ping.
I’ve gone back to mainline Lemmy. @[email protected] check now please
Bah! I totally forgot that they have the new “efficiency” cores…
Performance Cores: 6 Cores, 12 Threads, 2.5 GHz Base, 4.8 GHz Turbo
Efficient Cores: 8 Cores, 8 Threads, 1.8 GHz Base, 3.5 GHz Turbo
Hmmm, I’d still say its totally worth it because the 12500 only has 6 core (12 threads) total. You are getting 8 extra core/threads.
Linux/docker/anyOS will make use of 8 extra cores regardless of the workload. Sure they might not be as performent on the lower end but a process running 12 threads vs a process running 20 threads will always be more performant.
Ah. I see you too enjoy the debian approach