Great idea to compare plans across different systems using rows processed. A good yardstick, but slower sort-based plans from Postgres + MSSQL process fewer rows than faster hash-based plans from DuckDB. Postgres rows scanned also seem underreported. Nice to see some competition with ClickBench.

Here's what we've got in store for you!

🎓 E1: Torsten Grust (@teggy.org) (University of Tübingen) - Recursive Common Table Expressions (CTEs) Demystified

🧨 E2: Abigail Kim (@abigalekim.bsky.social) (Carnegie Mellon University) - Anarchy in the Database (deep dive into DBMS Extensibility)

The latest paper from the #1 CMU-DB PhD student @samarchdb.bsky.social is wild compilation magic! He automatically makes UDFs run 300x faster on SQL Server and 1.3x faster on DuckDB.
Code: github.com/SamArch27/PR...
Paper: www.vldb.org/pvldb/vol18/...