Comment by kscarlet
12 hours ago
On second thought, some skepticism on performance comparison:
1. do both systems access everything from memory?
2. do both systems have the same kind of indices?
3. do either system tradeoff scan performance for faster/acceptably fast updates?
1. Yes
2. No. Prela’s speedup is largely due to indexing. We tried to port the same indexing tricks back to duckdb but it wouldn’t let us. See the paper [1] for details
3. Prela focuses on analytical queries at least for now
[1]: https://arxiv.org/abs/2607.26356
Thanks! Kudos for the great work!