me is me@lemmy.ml to Lemmy@lemmy.ml · 2 years agoLemmy is blowing uplemmy.mlimagemessage-square145fedilinkarrow-up1142file-text
arrow-up1142imageLemmy is blowing uplemmy.mlme is me@lemmy.ml to Lemmy@lemmy.ml · 2 years agomessage-square145fedilinkfile-text
minus-squarejbenguira@lemmy-u3.vm.elestio.applinkfedilinkarrow-up6arrow-down1·2 years agoI think we really need to address the scaling issue, one option could be to use clichhouse instead of postgres
minus-squarehglman@lemmy.mllinkfedilinkarrow-up3·2 years agoThats certainly not the right kida of storage system for a site like this.
minus-squareTerrasque@infosec.publinkfedilinkEnglisharrow-up3·edit-22 years agoThis gives me MongoDB flashbacks. Postgres, if properly set up, should easily handle thousands of users.
minus-square777@lemmy.mllinkfedilinkarrow-up1·2 years agoI 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.
minus-squarebobaduk@lemmy.worldlinkfedilinkarrow-up1·2 years agoBit 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.
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.