3 ms·
The obvious is that an index is a tradeoff, slower writes and more disk space for faster reads. Unless the db can know disk space and write perf is worth the tr
by SigmundA 4y ago
The obvious is that an index is a tradeoff, slower writes and more disk space for faster reads. Unless the db can know disk space and write perf is worth the tradeoff it would be difficult for it to make good decision.
If you didn't care about disk space and the db could do async indexes but not have stale reads then an automatic index system could make sense.
- nikita 4y agoDisk space is becoming less of an issue in cloud environment with the rise of multi-tenant storage: aurora, neon (i'm ceo of neon). The cost of index maintenance is real and should be considered. Due to the multivariable nature of the this problem ML is the right approach to solve it and the ability to "prove" that it will work is also key.
- mejutoco 4y agoConstraint programming might be an alternative if we want "explainability".