this post was submitted on 31 Jul 2023
190 points (88.9% liked)

Fediverse

17535 readers
50 users here now

A community dedicated to fediverse news and discussion.

Fediverse is a portmanteau of "federation" and "universe".

Getting started on Fediverse;

founded 4 years ago
MODERATORS
[email protected]
[email protected]
190
Lemmy World is down once again. (lemmy.ml)
submitted 1 year ago by [email protected] to c/[email protected]
132 comments fedilink hide all child comments
 

Ugh.

you are viewing a single comment's thread
view the rest of the comments
[–] [email protected] 1 points 1 year ago* (last edited 1 year ago) (1 children)

It’s mostly DDOS attacks though, not the influx of normal users.

Really? As site_aggregates table getting 1500 rows updates is just the tip of the iceberg of how nobody has scrutinized the PostgreSQL performance. Thank you to lemmy.ca last weekend for looking.

[–] [email protected] 5 points 1 year ago (1 children)

As site_aggregates table getting 1500 rows updated on every single new comment

Is this accurate?

[–] [email protected] 2 points 1 year ago (1 children)

Do you know who runs lemmy.ca, accurate? https://lemmy.ml/post/2502514

[–] [email protected] 2 points 1 year ago* (last edited 1 year ago) (1 children)

Huh? I'm not an instance operator (yet). I was actually asking you a question, does this actually happen? Have you seen this on your own instance?

Was hoping to get some discussion going on this.

Edit: do you have any example logs from your postgres instance demonstrating this?

[–] [email protected] 2 points 1 year ago

do you have any example logs from your postgres instance demonstrating this?

I've exposed raw data from my PostgreSQL tables. And every single new comment and post you could see +1 going on every known server. I haven't updated to 0.18.3 yet, so it's still there: https://lemmyadmin.bulletintree.com/query/raw_site_aggregates?output=table