▲ 85 ▼ Lemmy World is down once again. (lemmy.ml) submitted 3 years ago by favrion@lemmy.ml to c/fediverse@lemmy.ml 114 comments fedilink hide all child comments Ugh.
[+] AlmightySnoo@lemmy.ml 1 point 3 years ago (1 child) [deleted] permalink fedilink source parent hideshow 2 child comments replies: [–] RoundSparrow@lemmy.ml 0 points 3 years ago* (1 child) It’s mostly DDOS attacks though, not the influx of normal users. 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. permalink fedilink source parent hideshow 2 child comments replies: [–] 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? permalink fedilink source parent hideshow 2 child comments replies: [–] RoundSparrow@lemmy.ml -1 points 3 years ago (1 child) Do you know who runs lemmy.ca, accurate? https://lemmy.ml/post/2502514 permalink fedilink source parent hideshow 2 child comments replies: [–] 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? permalink fedilink source parent hideshow 2 child comments replies: [–] 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 permalink fedilink source parent
[–] RoundSparrow@lemmy.ml 0 points 3 years ago* (1 child) It’s mostly DDOS attacks though, not the influx of normal users. 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. permalink fedilink source parent hideshow 2 child comments replies: [–] 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? permalink fedilink source parent hideshow 2 child comments replies: [–] RoundSparrow@lemmy.ml -1 points 3 years ago (1 child) Do you know who runs lemmy.ca, accurate? https://lemmy.ml/post/2502514 permalink fedilink source parent hideshow 2 child comments replies: [–] 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? permalink fedilink source parent hideshow 2 child comments replies: [–] 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 permalink fedilink source parent
[–] 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? permalink fedilink source parent hideshow 2 child comments replies: [–] RoundSparrow@lemmy.ml -1 points 3 years ago (1 child) Do you know who runs lemmy.ca, accurate? https://lemmy.ml/post/2502514 permalink fedilink source parent hideshow 2 child comments replies: [–] 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? permalink fedilink source parent hideshow 2 child comments replies: [–] 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 permalink fedilink source parent
[–] RoundSparrow@lemmy.ml -1 points 3 years ago (1 child) Do you know who runs lemmy.ca, accurate? https://lemmy.ml/post/2502514 permalink fedilink source parent hideshow 2 child comments replies: [–] 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? permalink fedilink source parent hideshow 2 child comments replies: [–] 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 permalink fedilink source 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? permalink fedilink source parent hideshow 2 child comments replies: [–] 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 permalink fedilink source 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 permalink fedilink source parent