About
I’m an MSc thesis student in computer science at the University of Waterloo and a member of the Data Systems Group, supervised by Professor David Toman.
My research focuses on query planning and optimization. I’m interested in how database systems turn declarative queries into efficient execution plans, and how search algorithms can make that process better. I have also studied how learned cost models can be moved to new hardware with only a few measured queries.
I also enjoy teaching. I’m currently a graduate teaching assistant at Waterloo, following three years of supporting undergraduate computer science and mathematics as a TA at the University of Toronto Mississauga.
Research
Ongoing thesis research · University of Waterloo
A* search for query planning
I’m exploring A*-based query planning in the ITB query compiler. The work considers how to construct and compare candidate plans while keeping the search space manageable.
Areas I’m investigating include:
- Selective generation of query-plan fragments
- Search-state representation and dominance pruning
- Cost estimation for partial plans
Papers
-
ManuscriptOctober 2026
Krish Patel. How few queries measured on a new machine are enough to adapt a learned PostgreSQL cost model, from 1,162 TPC-H and TPC-DS queries timed with identical plans in six environments. Grew out of my CS 680 course project.
PDFCode and dataSummary
Notes and talks
I write up papers I present or read closely, along with reports from course and research projects. Each one tries to say what the work establishes and where I think it stops short.
-
TalkCS 848, University of WaterlooOctober 2026
On C-Store (2005) and the two Abadi papers (2006, 2008). Which execution features explain the speedups, why the layout alone does not, and what Vertica, Snowflake, DuckDB and ClickHouse kept.
-
ProjectCS 680, University of WaterlooFall 2026
1,162 PostgreSQL queries timed with identical plans in six environments. One measured query per template, with a per-template offset, comes close to retraining; nothing helps on templates never measured.
-
TalkCS 886, University of WaterlooFall 2026
On Kaplan et al. (2020). The fitted power laws, the batch-size correction that the compute result depends on, and why the paper’s most quoted conclusion rests on its least robust number.
All notes and talks
Teaching
Graduate Teaching Assistant
Fall 2026
University of Waterloo
CS 115 · Introduction to Computer Science 1
I support students learning program design and functional programming. Please use the official course website for current course information.
Teaching Assistant
September 2022 – August 2025
University of Toronto Mississauga
I previously supported undergraduate courses in computer science and mathematics at UTM. My teaching experience includes the following courses.
Computer science
- CSC108Introduction to Computer Programming
- CSC148Introduction to Computer Science
- CSC207Software Design
- CSC209Software Tools and Systems Programming
- CSC263Data Structures and Analysis
- CSC343Introduction to Databases
Education
MSc, Computer Science
Fall 2026 – present
University of Waterloo · Thesis option
Supervisor: Professor David Toman
Honours Bachelor of Science
2025
University of Toronto Mississauga · High Distinction
Specialist in Computer Science · Minor in Mathematical Sciences