PhD Student in Databases @CMUDB with @andy_pavlo, Previously a Compiler Engineer @apple

Joined July 2023
2 Photos and videos
Sam Arch 🇦🇺 retweeted
3 Sep 2025
🧵Congrats to the #VLDB2025 award winners at @VLDBconf (London)! 🏆 • Best research papers: “Diva” (@niv_dayan @UofT @KTHuniversity) & “AnyBlox” (@JanaGiceva @tum_db) • Runner-up: “The Key to Effective UDF Optimization” by @CMUDB @andy_pavlo @pateljm
1
4
12
1,888
Sam Arch 🇦🇺 retweeted
The latest paper from the #1 CMU-DB PhD student @SamArchDB's is wild compilation DB magic! He automatically makes UDFs run 300x faster on @SQLServer and 1.3x faster on @duckdb. Code: github.com/SamArch27/PRISM Paper: vldb.org/pvldb/vol18/p1-arch…
6 Dec 2024
Vol:18 No:1 → The Key to Effective UDF Optimization: Before Inlining, First Perform Outlining vldb.org/pvldb/vol18/p1-arch…
2
29
222
20,548
Sam Arch 🇦🇺 retweeted
6 Dec 2024
Vol:18 No:1 → The Key to Effective UDF Optimization: Before Inlining, First Perform Outlining vldb.org/pvldb/vol18/p1-arch…
1
14
57
25,289
The UDF world tour continues. This week, I'm stopping at UW Madison, Microsoft's Gray Systems Lab, and The University of Washington. See you all there. 10/24 @wiscdb 10/25 @GraySystemsLab 10/25 @uw_db
I am flying to the Bay Area to give talks about my new VLDB 2025 paper on UDFs with @andy_pavlo and @pateljm. With our new technique (UDF outlining), queries run up to 1000× faster than FROID. The paper will drop soon. 9/10 @databricks 9/11  @UCBerkeley 9/12 #HTAPSummit2024
2
2
32
6,772
I am flying to the Bay Area to give talks about my new VLDB 2025 paper on UDFs with @andy_pavlo and @pateljm. With our new technique (UDF outlining), queries run up to 1000× faster than FROID. The paper will drop soon. 9/10 @databricks 9/11  @UCBerkeley 9/12 #HTAPSummit2024
2
10
105
29,491
Sam Arch 🇦🇺 retweeted
This speaks to me: it’s the essence of building hard things that take time to have impact, but then matter in a big way - you have to love the process, not just the outcome!
5 Sep 2024
Do what feels like play to you but looks like work to others.
11
55
476
45,326
Sam Arch 🇦🇺 retweeted
VLDB'24 Paper #1: Collecting training data for ML models with DBs is $$$/slow. @wanshenl's Boot framework uses @PostgreSQL extensions to cutoff redundant queries. Offline training goes from weeks to hours! • Code: github.com/lmwnshn/boot • Paper: x.com/pvldb/status/182834924…
27 Aug 2024
Vol:17 No:11 → Hit the Gym: Accelerating Query Execution to Efficiently Bootstrap Behavior Models for Self-Driving Database Management Systems vldb.org/pvldb/vol17/p3680-l…
1
10
68
8,671
Sam Arch 🇦🇺 retweeted
19 Aug 2024
Video of @SamArchDB 's talk from NYC Systems August 2024 is now up! Dear UDFs, I Broke Up With You, But Now I'm Ready To Give You A Second Chance. Will You Take Me Back? Sincerely, SQL youtube.com/watch?v=XMIEknQQ…
1
7
100
7,373
Sam Arch 🇦🇺 retweeted
🇦🇺s incoming
8 Aug 2024
The next NYC Systems talks are Thursday August 15th. Very pleased to have @jonobelotti_IO of @modal_labs speaking about serverless cold starts, and @SamArchDB of @CMUDB speaking about SQL UDFs! nycsystems.xyz/august-2024.h…
1
8
1,784
Sam Arch 🇦🇺 retweeted
Replying to @_TylerHillery
We have three more bombs dropping this month from @lmwnshn @SamArchDB William Zhang. @abigale_kim just submitted her VLDB paper last week too. It's going to be a blow out year.
2
7
66
3,187
Sam Arch 🇦🇺 retweeted
It took three years to finish, but our follow-up to the 2006 "What Goes Around Comes Around" is finally out! Stonebraker and I examine the last 20 years in databases and discuss why relational databases SQL will continue to remain on top. 📄PDF: db.cs.cmu.edu/papers/2024/wh…
24
335
1,262
172,952
Sam Arch 🇦🇺 retweeted
3 Jun 2024
We are proud to release the first major version of DuckDB, v1.0.0, codenamed "Snow Duck". This version is a culmination of almost six years of research and development. Today we are shipping an innovative database system with a backwards-compatible storage format. Check out our announcement blog post: duckdb.org/2024/06/03/announ…
25
271
985
123,365
Sam Arch 🇦🇺 retweeted
Here is a short video from my recent interview with @SCSatCMU's media team on the one year anniversary of the infamous @Jeopardy "matrix" scandal: instagram.com/reel/C6Y5SCPrF…
1
4
8
3,279
Sam Arch 🇦🇺 retweeted
I am excited to announce that I will start my PhD in database systems at @wiscdb and work with @xiangyao_yu beginning Fall 2024! I'm super grateful to everyone who has supported me along the way :)
9
3
150
22,034
Sam Arch 🇦🇺 retweeted
My #1 PhD student @butro successfully completed his PhD defense. Thanks to the committee (@pateljm @justinesherry @samrmadden). Matt's thesis is on accelerating databases with eBPF (telemetry, proxies, OLTP stores). You have 60 days to hire him. Expect fierce competition.
3
8
254
30,947