Readyset DB: Optimizing Cold Path Query Performance with ICP
2025-08-23
Readyset database achieved a significant breakthrough in query performance during cache misses (cold path), specifically for straddled joins where predicates filter both join sides. The previous hash join algorithm proved inefficient due to extensive reads of irrelevant data. By introducing Index Condition Pushdown (ICP), Readyset combines the left-side predicate results with the right-side predicates, enabling precise data retrieval at the storage engine level, avoiding full table scans. Benchmarks show a >450x throughput improvement and >450x latency reduction, effectively resolving the performance bottleneck of cold path queries.
Read more