From Postgres to a Minimalist Lakehouse: The Next Step with DuckLake - Mehdi Ouazza - MotherDuck

🔥 How do you move from Postgres OLTP to a minimalist lakehouse with DuckDB and DuckLake? 🔥 Why design for the 90 percent of queries (≤1 GB scans) to avoid the big data tax? 🔥 How do you get under 1s on 4 GB with DuckDB and under 1 min on 255 GB with MotherDuck? Mehdi Ouazza, Developer Advocate at MotherDuck. A minimalist lakehouse: Postgres to DuckDB to DuckLake and MotherDuck on S3, built with a laptop and CLI. Design for the 90 percent (≤1 GB), run under 1s on 4 GB locally and under 1 min on 255 GB in MotherDuck. 🤔 Did you know he stood up an end-to-end lakehouse with just a laptop and S3 in under 20 minutes? ____________________________ 🤘🤘🤘FWD designed, built and organized with 🧡 by ‪‪‪‪‪@hymaia‬ (https://www.hymaia.com ) — with ‪‪‪‪‪@blef_‬ & ‪@moderndatanetwork4589‬ 🌐🌐🌐 MORE DATA CONTENT on our channels: ➜ LinkedIn :   / 104059598   ➜ Twitter : https://x.com/ForwardDataconf ➜ Instagram :   / forwarddataconf   ➜ TikTok :   / hymaiafr   💻 Our website : https://www.forward-data-conference.com/ 🔥🔥🔥 Our 2025 Sponsors: Omni, Sifflet, Mirakl, Tangram-os.ai, starlake, synq, clickhouse, Nao, DataBricks 🎬CHAPTERS 00:00:00 Introduction 00:00:17 Why a minimalist lakehouse 00:01:22 From Hadoop pain to OLTP to analytics 00:03:41 Toolkit: laptop plus S3 plus DuckDB 00:10:49 Postgres vs DuckDB: 12s vs under 1s on 4 GB 00:13:56 DuckLake architecture and demo 00:19:10 MotherDuck in the cloud and key takeaways © 2025 Hymaïa - Cabinet de conseil et Formation Product, Data & IA TITLES AND HASHTAGS === 1. From Postgres to a Minimalist Lakehouse with DuckDB & DuckLake Hashtags : #DuckDB #DuckLake #Postgres #Lakehouse #DataEngineering 2. DuckDB on S3: Build Analytics from a Laptop in Minutes Hashtags : #MotherDuck #S3 #AnalyticsEngineering #ModernDataStack #SQL 3. Design for the 90%: Faster Analytics with DuckDB and DuckLake Hashtags : #DuckDB #DuckLake #Performance #DataPlatform #GitHubActions