This would be neat to generate forum avatars, to show something similar to your real face.

The post yes, but not the comments at depth > 50.

No the max comment depth is generally lower now. However this doesnt affect comments created before upgrading.

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 @[email protected], thanks for that!

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

No domestic flight, just Europe -> Texas -> Mexico.

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.

Or you guys like to be shouted at. There is no other country that does this.

Not like that, they didn’t let me board my flight from Europe to Texas. Even though I had a connecting flight to Mexico few hours later. Why can’t they have a visa free transit zone like every other country in the world?

I only stopped there for transit on a flight to Mexico. Just before boarding my flight I was told that I need a visa for the US, which is extremely weird because normally airports have transit zones where you don’t need any visa. But apparently the US is special, so you actually have to enter the country before going right back into the airport. This nonsense made me miss my flight.

Also I remember in the airport there was a security guard doing nothing but shouting nonstop that it’s not allowed to carry water. Why not simply put up a sign?

Good reply, like you explain this wouldn’t work. Just one thing:

Lemmy doesn’t aim to be an uncensorable platform.

https://join-lemmy.org/docs/users/05-censorship-resistance.html

I dont know about you, but our rice cooker seems quite high tech. It can even talk!

You can always use a knife instead.

Here: https://github.com/LemmyNet/lemmy/issues

@[email protected] This. If youre interested to work on this feature or others, feel free to ask for guidance in the relevant issue, or in the dev chat.

You can use pg_stat_statements to find slow queries. Try sorting by top total_exec_time.

Good example of AI making stuff up instead of simply saying “I don’t know”.

No that’s not merged yet, still needs more feedback from plugin devs.

The key is refreshed after 24 hours so it will work if you wait a bit.