191
Lemmy World is down once again.
(lemmy.ml)
A community dedicated to fediverse news and discussion.
Fediverse is a portmanteau of "federation" and "universe".
Getting started on Fediverse;
Move to a new, smaller, instance. You can still use lemmy.world as though it was still running at full speed. You can still post to lemmy.world or other federated communities and you experience won’t be so painful.
Lemmy.world is experiencing an influx of Redditors and with us good Redditors come our awful trolls. Growth, along with DDoS attacks have plagued the site since I began using it.
Really? As site_aggregates table getting 1500 rows updated on every single new comment and post local insert is just the tip of the iceberg of how nobody has scrutinized the PostgreSQL performance. Thank you to lemmy.ca last weekend for looking at AUTO_EXPLAIN on their data.
Is this accurate?
Do you know who runs lemmy.ca, accurate? https://lemmy.ml/post/2502514
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?
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