How do you feel about the massive influx of users?
this post was submitted on 10 Jun 2023
142 points (100.0% liked)
Lemmy
13127 readers
42 users here now
Everything about Lemmy; bugs, gripes, praises, and advocacy.
For discussion about the lemmy.ml instance, go to [email protected].
founded 5 years ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
I think we really need to address the scaling issue, one option could be to use clichhouse instead of postgres
Thats certainly not the right kida of storage system for a site like this.
This gives me MongoDB flashbacks. Postgres, if properly set up, should easily handle thousands of users.
I think probably a pluggable storage backend is the best move. For example, any cloud hosted instance could use a native document storage format such as dynamodb, which is often quite cheap or free for small use-cases.
Bit of a pain to store in Dynamo, though. You'd need to write a bunch of different views, I think.
One comment thread makes sense as a partition, but listing threads is going to be awkward, and search is basically a no-no.