Changing post.url from varchar(512) to varchar(2000) really messed up database performance so lemmy.ml became unusable. Turns out that column statistics are removed when the type is changed, so we had to run analyze as part of the migration. Seems like a bug in postgres.

https://github.com/LemmyNet/lemmy/issues/4983#issuecomment-2446945046

Dont think I did, it was really a team effort. And in the end the working solution was suggested by @phiresky@lemmy.world, thanks for that!

It will be rejected by the api (or by federation).

Thank you, fixed!

In principle it’s finished, but last time we put it on lemmy.ml for testing there were performance problems and we had to revert. So far it’s not clear what caused those problems, so we need to try again somehow.

To decide if I should merge the linked PR or not (I did merge it).

Thats even more verbose so the second option is better.

@DemocratPostingSucks@lemm.ee @Deebster@programming.dev @al4s@feddit.org Thanks for the feedback! Personally I prefer the first option, but based on your comments I will merge the PR with the second option.

Ah yes Im a liability to Lemmy which wouldnt even exist without my work. Troll harder kiddo.

Not sure, I just got back to work this week and need to catch up with everything.

Big words from someone who posts anonymously, and who never contributed anything positive to the internet.

I just checked out your website, you have a lot of active projects, impressive! I only work on Lemmy, fulltime, but yet there is way too much work.

That’s only one developer, but you were talking in plural. What other Lemmy dev are you referring to?

It seems there are always people on the internet who spread negativity about those who actually create things. Best you can do is ignore them.

I haven’t seen that community before. Some people have way too much time on their hands to keep posting about things they dislike. But at least it proves that censorship on Lemmy is impossible, when not even us developers can do it.

Wait, when have I ever denied any genocide?

I pay around 80€ per month for the lemmy.ml server, plus a few euros for image hosting and domain. So that’s around 3 cents per active user.

I believe there is still an open issue on Github for this, but no one was interested to help implement and test it. So use the search function and contribute!

Thanks!