Stanislav’s Big Data Stream (Substack)

Postgres Can Be Your Data Lake (Pg_lake)

In this episode Marco introduces PgLake, an extension that lets PostgreSQL query and manage data lakes stored as Iceberg tables in object storage. By delegating analytical queries to DuckDB’s vectorized engine, PgLake can achieve up to 100× faster performance than native PostgreSQL on the same data. The discussion covers why traditional PostgreSQL struggles with analytics, how PgLake bridges the gap between operational and analytical workloads, and practical patterns like materialized views and incremental loads that let teams keep using familiar SQL tools while leveraging columnar storage.