pg_lake: Postgres as a lakehouse | POSETTE: An Event for Postgres 2026

Microsoft Developer
AI summary

This talk presents pg_lake, a set of open-source Postgres extensions that add DuckDB query engine and Iceberg table format support to enable analytics workloads directly in Postgres. Marco Slot demonstrates how to query and manage data lake files via SQL, create high-performance analytical tables, and combine pg_lake with pg_incremental for production data engineering patterns. Ideal for Postgres developers and data engineers building modern data platforms.