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.

https://reddthat.com/signup

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!

That awkward moment when you are the person they are talking about when running beta in production!

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

Make sure to read the side bar. Support questions go to !askandroid@lemdro.id

See my PR for a new backup script. https://github.com/LemmyNet/lemmy-ansible/pull/210

I’ll get to adding it to the main docs on the weekend.

Tldr, piping your backups via docker is CPU expensive. Directly writing to filesystem in a postgres compatible format with compression is faster and more efficient on the CPU.

My 90GB+ (on filesystem) db compresses to 6GB and takes less than 15 mins.

Been running this since -rc1 & 0.19.1 for the past 13 hours. No issues related to Federation since! just higher CPU load compared to 0.18.x releases.

Thanks for another great release. Suppose I should go fix our ansible ey?

Should be fixed. (It already got merged: https://github.com/LemmyNet/lemmy/pull/4213)

It’s a sad day when something like this happens. Unfortunately with how the Lemmy’s All works it’s possible a huge amount of the initial downvotes are regular people not wanting to see the content, as downvotes are federated. This constituted as part of my original choices for disabling it when I started my instance. We had the gripes people are displaying here and it probably constituted to a lack in Reddthat’s growth potential.

There needs to be work done not only for flairs, which I like the idea of, but for a curated All/Frontpage (per-instance). Too many times I see people unable to find communities or new content that piques their interest. Having to “wade through” All-New to find content might attribute to the current detriment as instead of a general niche they might want to enjoy they are bombarded with things they dislike.

Tough problem to solve in a federated space. Hell… can’t even get every instance to update to 0.18.5 so federated moderation actions happen. If we can’t all decide on a common Lemmy instance version, I doubt we can ask our users to be subjected to not using the tools at their disposal. (up/down/report).

Keep on Keeping on!

Tiff - A fellow admin.

No worries! I hope the community comes back around!

Yeah funding is good. Completely community funded :) Ours is on open collective if you want to see it 😉 (we are completely transparent)

We (reddthat) would welcome your community. 😉

Hello,

Please see the rules of reddthat here: https://reddthat.com/post/9701

No racism or other discrimination No endorsement of hate speech

As such you have broken our rules, specifically being racist. You have remained civil and I thank-you for that. Normally I would have banned the account in question by now, but have decided not too unless others end up reporting your comments, but I see that as unlikely as this has become a worthwhile discussion.

What has your post in the community abandonedporn got to do with this? Nothing. This is an offtopic conversation which you started off with zero context. And text with zero context can be read with a myriad of inflections even when the best intentions are meant.
If you started off saying you knew the area, or lived down the road, that may have some credibility and then tied into your current feelings about the issue then we wouldn’t have had a problem if you said it in a way that acknowledged it was your own opinion. Like how you have now is amazing, I wish all comments were as thoughtful as this. But you chose to originally post in a community that has next to nothing to do with Russia to voice your opinion on your dislike.

Hatred towards any country is not welcome on Reddthat. I understand your feelings and they are worth while.

I look forward to seeing you in a different community, maybe a political community to have a discussion.

Thankyou

Reddthat Admin Team

Please do not bring your hatred of a few against a whole population. That type of hatred is against Reddthat’s rules.

Please refrain from future comments like that.

Oh that’s super nice!
That’s why I asked if they were hiring. Sounds like a nice place to work. I work at a job that doesn’t allow me to have non-work time during my allotted on-work time. ie 9-5.

Obviously I agree that this is definitely on the riskier side of the line, whether it crosses into NSFW territory is unfortunately dependant on everyone’s own definition.

See the other comment(s) from Red that go into detail regarding what is going to be done regarding the future of the community and the riskiness.

Removing the post at this time would not be for the benefit of the community when we can have active discussions on what we want the community to become.
Unfortunately I have a feeling that some of the commenters here are from All and are not active subscribers. So they may not be used to seeing content like this. They also may not understand the difference between instances and the nuances with federation.

Edit: This is the comment from Red regarding what we are going to do: https://reddthat.com/comment/2250572

But you are doing it while you are “at work”? So you are using company time to look at fediverse content.