As a first step, we will go through query planning to better understand potential bottlenecks. Then, we will discuss the practical implications of indexing, sharding, and partitioning strategies, and provide practical advice on how to further optimize CrateDB queries for optimal performance. All these topics will be covered by real-world examples and practical solutions to some of the most common issues. At the end of the talk, you will be equipped with practical tips and techniques for detecting performance issues and optimizing your queries.
- Intro to CrateDB and query plans
- How different sharding, partitioning, and indexing strategies affect query performance
- Real-life examples and tips for debugging slow queries