Scale By The Bay 2020: Rohit Jain & Bin Fan, Optimizing Latency-Sensitive Queries for Presto...
ai.bythebay.io Nov 2025, Oakland, full-stack AI conference Title: Optimizing Latency-Sensitive Queries for Presto at Facebook For many latency-sensitive SQL workloads, Presto is often bound by retrieving distant data. In this talk, Rohit Jain, James Sun from Facebook and Bin Fan from Alluxio will introduce their teams’ collaboration on adding a local on-SSD Alluxio cache inside Presto workers to improve unsatisfied Presto latency. This talk will focus on: -Insights of the Presto workloads at Facebook w.r.t. cache effectiveness -API and internals of the Alluxio local cache, from design trade-offs (e.g. caching granularity, concurrency level and etc) to performance optimizations. -Initial performance analysis and timeline to deliver this feature for general Presto users. -Discussion on our future work to optimize cache performance with deeper integration with Presto Rohit Jain Software Engineer, Facebook Technologist. Specializes in building large scale distributed systems. Loves solving real-world complex problems. Bin Fan VP of Open Source, Founding Engineer, Alluxio, Inc. Bin Fan is the founding member of Alluxio Inc and the PMC member of Alluxio open source project. Prior to Alluxio, he worked for Google to build the next-generation storage infrastructure and won Google’s Technical Infrastructure award. Bin got his Ph.D. in Computer Science from Carnegie Mellon University on the design and implementation of distributed systems and algorithms.