Use cases

End-to-end examples of pg_lake applied to real workloads. Each one can be run as written on a pg_lake installation with object storage.

Sync Postgres tables to Iceberg Keep an Iceberg copy of operational tables up to date with pg_incremental, and query it from any Iceberg engine without ETL. Log management Turn log files in object storage into a compact Iceberg table, processing each new file exactly once. Archive partitions to Iceberg Keep recent rows in heap partitions and move old months into a partitioned Iceberg table. Fast analytics dashboards Serve dashboards from Iceberg tables with sub-second aggregates over millions of rows, and keep rollups up to date for busy panels. Geospatial analytics Query public GeoParquet and Shapefiles in place, extract them into Iceberg and PostGIS tables, run spatial joins and map the results in QGIS.