Re:Show HN: ToroDB Stampede: Automagical MongoDB to PostgreS...
by ahachete on Thursday December 01, 2016 @07:06AM
(#13078829)
So far we have benchmarked situations where dataset > RAM or >> RAM. I think it is an interesting point to also analyze the case when dataset < RAM, to see how efficiently both systems manage the caches, query planning etc. Stay tuned and thanks for the suggestion! :)
Anyway, my point stands. I'd use a single instance in which the dataset fits in memory, just for completeness. Then, you can compare one mongo with the full dataset to one stampede.
As you said, the aggregated data will still make Mongo suffer, but it will be a better comparison. I still like the 3-shard setup, though. It's also a good reference point.