RocketDerp

Yha, I do see the code to federate outbound DeleteAccount: https://github.com/LemmyNet/lemmy/blob/main/crates/apub/src/activities/deletion/delete_user.rs#L54C11-L54C11 These problems were already happening, this issue has been opened for over a month, since June 17. I suggest...

I see [people are talking on Lemmy about multiple servers being down](https://lemmy.ml/post/2359557) in the past 4 hours. I know there is an .up SQL file and .down SQL so you...

@Sh4d - if you have it handy, what is the full SQL statements being generated, the DELETE transactions, Lemmy generates? is there even a DELETE at all? https://github.com/LemmyNet/lemmy/issues/3649 mentions: `...

So why is an INSERT and DELETE trigger even being invoked on an UPDATE? I understand the I/O problems with the INSERT (new comment), but I haven't yet come across...

``` create trigger site_aggregates_comment_delete after delete on comment for each row when (OLD.local = true) execute procedure site_aggregates_comment_delete(); ``` This is native PostgreSQL syntax here, `after delete on comment` means...

Ok, thank you for the sanity check. That was from down.sql, the previous code before April 4, 2022.

I've been building messaging systems professionally since 1985, including extensive work with near real-time transactions using PostgreSQL as a backend. I agree that it needs to shift away from directly...

> if inserts take 0.4 seconds on average something is very wrong somewhere else. This was a mistake, it's less than 1ms. Units was read wrong, sorry. > Server operators...

> The rust code also does a ton of unnecessary sql selects that it then doesn't even use. Can we get started on this? Where, here on Github? With federation...

Back to the topic of the posting title, federation queues. I recommend that the project immediately have an admin API on some of the internal state and statistics. It's getting...