216
submitted 1 year ago by favrion@lemmy.ml to c/fediverse@lemmy.ml

Ugh.

you are viewing a single comment's thread
view the rest of the comments
[-] RoundSparrow@lemmy.ml 2 points 1 year ago* (last edited 1 year ago)

That’s why I use lemm.ee

1993: God, how we would love it if someone could tell us anything was “just that simple”, and then of course when you see a pie chart you go “Oh, a pie chart…”. I mean, it has more religious meaning now than a crucifix to see a pie chart. I mean, because…. why is that so popular? Because it reduces complexity. The complexity is very real but his little soundbites - 1993

@garpunkal@lemm.ee - do you know of the history of site_aggregates PostgreSQL table?

[-] boot@lemmy.loungerat.io 5 points 1 year ago
[-] RoundSparrow@lemmy.ml 1 points 1 year ago* (last edited 1 year ago)

huh?

Please explain in detail what "huh" means in this context.

As I said in the comment you replied to: do you know of the history of site_aggregates PostgreSQL table?

[-] WarmSoda@lemm.ee 3 points 1 year ago

Not OP, but I feel like it was Huh? as in what the heck are you talking about and why was it a reply to thier comment

[-] garpunkal@lemm.ee 1 points 1 year ago
[-] RoundSparrow@lemmy.ml 1 points 1 year ago

lemmy.ca staff was so frustrated with performance problems a couple weekends ago they cloned a copy of their database Running AUTO_EXPLAIN revealed site_aggregates logic in Lemmy was doing comment = comment + 1 counting against 1500 rows, for every known Lemmy instance in the database, instead of just writing 1 row.

this post was submitted on 31 Jul 2023
216 points (100.0% liked)

Fediverse

17739 readers
18 users here now

A community dedicated to fediverse news and discussion.

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

Getting started on Fediverse;

founded 5 years ago
MODERATORS