Name: Kansas City Data Professionals: Unifying transactional and analytical data with Postgres
Start: 2026-04-30T17:30:00.000-05:00
End: 2026-04-30T19:00:00.000-05:00
Location: 710 Central St

KC Digital Drive

pg_lake: Unifying transactional and analytical data with Postgres

This is a special event.  KC Data Professionals and KC Postgres User Groups are joining forces!

The data world used to be defined by “transactional" (OLTP) and “analytical” (OLAP) workloads but we’ve asked ourselves “Why not both?”. A new series of extensions called pg_lake has just been released to connect Postgres to object storage and open table formats - like csv, Parquet, and Iceberg. pg_lake bridges the two worlds of transactional and analytical data for a vendor neutral, open source, unified data stack.

This talk will explore the pg_lake extension, including how to build it, and demos of using it with modern data workloads in object storage like Amazon s3. We’ll create simple data pipelines with no ETL and high performance analytics.

pg_lake is more than just an extension. It is the foundation to a fully unified data path with 100% open source tools backed by PostgreSQL, DuckDB, Iceberg, and Polaris.

Parking and Access: Parking is free and available in any of the Hive spots on the north side of the lot just east of the building. Enter on the east side near the southwest corner of 7th and Central Street. Take the elevator to the 3rd floor and check in at the registration desk.