3 ms·
Not an expert on the traditional database. Do they also have a benefit similar to the compression that comes from record re-ordering in column databases? It's
by onlyrealcuzzo 3y ago
Not an expert on the traditional database.
Do they also have a benefit similar to the compression that comes from record re-ordering in column databases?
It's not just that you need to read a smaller section of disk to scan the same amount of interesting data - it's that that data also takes up considerably less space than it otherwise would.
- coatue 3y agoHi, hydra cofounder here. catching up on the thread since we were submitted by the community! Yes, it depends on the data, but we've observed customers with a 10X data compression over Postgres (heap) tables although ~5-7X is more common.