astral_avocado comments on Lemmy World is down once again.

[–] astral_avocado@programming.dev 0 points 3 years ago (1 child)

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

Is this accurate?

parent

[–] RoundSparrow@lemmy.ml -1 points 3 years ago (1 child)

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

parent

[–] astral_avocado@programming.dev 2 points 3 years ago* (last edited 3 years ago) (1 child)

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?

parent

[–] RoundSparrow@lemmy.ml 2 points 3 years 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

parent

lemmy:	0.19.20
mlmym (mschae):	26.3.3