6 ms·
If all this data just fits in memory then what is surprising about the speed?
by n0tme 9y ago
If all this data just fits in memory then what is surprising about the speed?
- bufferoverflow 9y agoWell, you can try and run MySQL or Postgre off a RAM drive, but I suspect you won't get close to this result. And then your data is not on a reliable storage media.
- n0tme 9y agoCan't talk about MySQL or PostgreSQL, but with Oracle I am pretty sure you can get very much close to this result with cached data. And this is without using the in-memory option. However, talking about it withouth any experiments to prove a point is just speculation. Memory vs Disks changes a lot performance-wise.
- exikyut 9y agoIt was expressly forbidden in the software contract to benchmark Oracle back in the 80s. https://danluu.com/anon-benchmark/ https://danluu.com/anon-benchmark/
- captain_perl 9y agoIt's forbidden to publish the benchmarks, not to make them. And it's because most users are rubes who can't tune 2 databases at the same time.
- olavgg 9y agoWith the ClickHouse OLAP db I'm limited by memory bandwidth.
- neildahlke 9y agoI believe you're conflating the name with the actual contents of the post. The demo uses the MemSQL columnstore, which is disk-based and leverages memory only for indexes, metadata, query processing etc.