Are updatable learned indexes ready?

C Wongkham, B Lu, C Liu, Z Zhong, E Lo… - arXiv preprint arXiv …, 2022 - arxiv.org
C Wongkham, B Lu, C Liu, Z Zhong, E Lo, T Wang
arXiv preprint arXiv:2207.02900, 2022arxiv.org
Recently, numerous promising results have shown that updatable learned indexes can
perform better than traditional indexes with much lower memory space consumption. But it is
unknown how these learned indexes compare against each other and against the traditional
ones under realistic workloads with changing data distributions and concurrency levels. This
makes practitioners still wary about how these new indexes would actually behave in
practice. To fill this gap, this paper conducts the first comprehensive evaluation on updatable …
Recently, numerous promising results have shown that updatable learned indexes can perform better than traditional indexes with much lower memory space consumption. But it is unknown how these learned indexes compare against each other and against the traditional ones under realistic workloads with changing data distributions and concurrency levels. This makes practitioners still wary about how these new indexes would actually behave in practice. To fill this gap, this paper conducts the first comprehensive evaluation on updatable learned indexes. Our evaluation uses ten real datasets and various workloads to challenge learned indexes in three aspects: performance, memory space efficiency and robustness. Based on the results, we give a series of takeaways that can guide the future development and deployment of learned indexes.
arxiv.org