this post was submitted on 10 Jun 2023
694 points (99.6% liked)

Lemmy

12459 readers
1 users here now

Everything about Lemmy; bugs, gripes, praises, and advocacy.

For discussion about the lemmy.ml instance, go to !meta@lemmy.ml.

founded 4 years ago
MODERATORS
 

How do you feel about the massive influx of users?

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

Indeed PostgreSQL is not designed for large scale horizontal sharding with eventual consistency. Also ClickHouse is designed for OLAP workloads likely making it even less suitable.

Regardless of database choice, Lemmy is still centralized. Discussion groups are cached across instances but not truly distributed. This is the big blocker.