3 ms·

PG and Mongo will vertically scale about the same depending on your queries. They were probably using sharding with tiny instances which is dumb. Also, large do

by winrid 2y ago

PG and Mongo will vertically scale about the same depending on your queries. They were probably using sharding with tiny instances which is dumb. Also, large documents doesn't really hurt performance with mongo, except maybe with writes, or with large array fields due to replication implication.

LtWorf 2y ago
Not large documents, but documents where the most common operation is to add a number to a list of numbers.
- winrid 2y ago
  Yeah that's a bad idea. You should instead just create a doc for each number. Each time you add a number the entire list needs copied to disk and to each secondary, so the cost grows quickly with each write.
  - LtWorf 2y ago
    I know, but the "seniors" in that place didn't