2 ms·
You realise that Reddit is over 10 years old. There would have been trillions of votes since then. What database are you thinking that could store all of those
by threeseed 8y ago
You realise that Reddit is over 10 years old. There would have been trillions of votes since then.
What database are you thinking that could store all of those and then I assume aggregate them ? Kind of curious about this proposed architecture.
- extra88 8y agoI would expect vote sums to be stored separately, you don't need to query a table containing all votes on every page load any more than a bank needs to query all transactions to show your account balance.
- jedberg 8y agoPostgres. And that's exactly how it has been. Every vote is a row that gets post-processed.
- intended 8y agoWouldn’t that database be just positively massive? How fast does the database grow?