--- title: "Postgres Live - Transparent Hot and Cold Tiering for Postgres: ColdFront" description: Got Postgres sprawl? Tired of chasing down performance issues? We're hosting an open technical session to walk through how the pgEdge AI DBA Workbench works — and to hear what the community thinks. Dave Page (CTO, creator of the AI DBA Workbench, creator of pgAdmin, and longtime Postgres Core Team Member), Antony Pegg (Director of Product Management), and Paul Rothrock (Solutions Engineer) will do a live, unscripted walkthrough and take questions throughout. --- On Demand Webinar Postgres Live: Monthly Series Transparent Hot/Cold Tiering for Postgres: ColdFront Deep Dive + Live Demo   - **Description** Postgres databases grow — and most of that data sits on expensive SSD storage that nobody's queried in months. ColdFront is pgEdge's open source transparent tiering system that moves cold data to Apache Iceberg on cloud object storage (up to 90% cheaper storage) while keeping OLTP, analytics, and AI workloads running against the same tables, using the same SQL and same connection string. No application changes. No vendor lock-in. In this live webinar, Jimmy Angelakos (Staff Software Engineer and lead developer behind ColdFront) will walk through the project itself as well as the engineering decisions behind it, and Paul Rothrock (Solutions Engineer) will deliver a live demo: from setup through creating dual-mode (hot/cold) tables, Iceberg-only tables, and traditional partition management, with reads, writes, and deletes against cold data. Key topics: - Why existing approaches (ETL pipelines, proprietary tiering, dump-to-files) each have a structural problem - How ColdFront routes queries transparently across hot Postgres partitions and cold Iceberg files — without a sidecar process or remote procedure call - The writable cold tier: why read-only archival creates real operational problems for GDPR, auditing, and corrections, and how ColdFront handles it - Architecture walkthrough: C extension, pg\_duckdb (in-process), Archiver Go binary, Lakekeeper, and why 'as few moving parts as possible' drove every choice - Getting multi-writer correctness right: serialising concurrent cold writes across pgEdge Spock nodes with a Lamport-style bakery protocol, model-checked in TLA+ - Live demo: setup, dual-mode tables, Iceberg-only tables, traditional partitions, archiving, and querying across both tiers Give ColdFront a try anytime: [https://github.com/pgEdge/ColdFront](https://github.com/pgEdge/ColdFront) Fill out the form to watch this session on-demandRegister below to reserve your spot today!  ## Speakers ![_0004_pgEdge_web_company_team_Ant (2)](https://pages.pgedge.com/hs-fs/hubfs/_0004_pgEdge_web_company_team_Ant%20(2).png?width=384&height=384&name=_0004_pgEdge_web_company_team_Ant%20(2).png) ### Antony Pegg, Director, Product Management ![Paul Rothrock, Systems Engineer](https://pages.pgedge.com/hs-fs/hubfs/Paul%20Rothrock.jpg?width=1468&height=1835&name=Paul%20Rothrock.jpg) ### Paul Rothrock, Systems Engineer ![_0002_pgEdge_web_company_team_jimmy (2)](https://pages.pgedge.com/hs-fs/hubfs/_0002_pgEdge_web_company_team_jimmy%20(2).png?width=384&height=384&name=_0002_pgEdge_web_company_team_jimmy%20(2).png) ### Jimmy Angelakos, Staff Software Engineer ### Postgres Live: Monthly Series Transparent Hot/Cold Tiering for Postgres: ColdFront Deep Dive + Live Demo - ![linkedin](https://pages.pgedge.com/hs-fs/hubfs/linkedin.png?width=32&height=32&name=linkedin.png) - ![twitter](https://pages.pgedge.com/hs-fs/hubfs/twitter-1.png?width=32&height=26&name=twitter-1.png) - [![mail](https://pages.pgedge.com/hs-fs/hubfs/mail.png?width=31&height=25&name=mail.png)](mailto:?subject=&body=) 2025 ©pgEdge, Inc. [Terms of Use](https://www.pgedge.com/terms-of-service) [Privacy Policy](https://www.pgedge.com/privacy-policy) [Cookie Policy](https://www.pgedge.com/cookie-policy) [Community License](https://www.pgedge.com/communitylicense) [Evaluation License](https://www.pgedge.com/pgedge-platform-evaluation-license-agreement)