---
title: "Introducing ColdFront: Seamlessly Uniting OLTP, Analytics and AI Workloads on PostgreSQL"
url: https://daily.dev/posts/introducing-coldfront-seamlessly-uniting-oltp-analytics-and-ai-workloads-on-postgresql-d3xypxemt
source_url: https://postgr.es/p/9mf
type: article
source: "Planet PostgreSQL"
published: 2026-06-18T16:16:56.776Z
updated: 2026-06-18T17:47:05.047Z
tags: ["postgresql", "duckdb", "apache-iceberg"]
reading_time: 9
upvotes: 0
comments: 0
language: en
---

> ## Documentation Index
> Fetch the complete documentation index at: https://daily.dev/llms.txt
> Use this file to discover all available pages before exploring further.

# Introducing ColdFront: Seamlessly Uniting OLTP, Analytics and AI Workloads on PostgreSQL

**[Planet PostgreSQL](https://daily.dev/sources/planet-postgresql)** · 9 min read · 0 upvotes · 0 comments

## Summary

pgEdge has released ColdFront v1.0.0-beta1, an open-source transparent data tiering extension for PostgreSQL that unifies OLTP, analytics, and AI workloads. Its headline feature is a fully writable cold tier — archived data can be updated or deleted via standard SQL without restoring it to hot storage first. ColdFront runs on stock upstream PostgreSQL 17/18 with no proprietary forks, uses Apache Iceberg (Parquet on S3-compatible storage) for cold data, and embeds DuckDB in-process for columnar analytical performance. Applications interact with a single table name regardless of which tier data lives in, requiring no code changes. A distributed bakery protocol (model-checked in TLA+) enables concurrent cold writes across pgEdge Spock mesh nodes. The tool also handles full partition lifecycle management, supports 2-level tenant-by-time sub-partitioning, and is positioned for AI governance workloads requiring append-heavy writes with mandatory retention and occasional corrections.

## Full article

daily.dev links to this article rather than hosting it. Read it at the original source: <https://postgr.es/p/9mf>

## Similar posts on daily.dev

- [pgEdge Announces ColdFront for PostgreSQL, Seamlessly Uniting AI, Analytical and OLTP Workloads](https://daily.dev/posts/pgedge-announces-coldfront-for-postgresql-seamlessly-uniting-ai-analytical-and-oltp-workloads-wwcqverhk) · SD Times · 1 upvotes · 0 comments
- [pgEdge joins rush to merge OLTP and OLAP storage to support AI](https://daily.dev/posts/pgedge-joins-rush-to-merge-oltp-and-olap-storage-to-support-ai-ih2dhykb8) · InfoWorld · 0 upvotes · 0 comments

---

Tags: [#postgresql](https://daily.dev/tags/postgresql), [#duckdb](https://daily.dev/tags/duckdb), [#apache-iceberg](https://daily.dev/tags/apache-iceberg)

[View this post on daily.dev](https://daily.dev/posts/introducing-coldfront-seamlessly-uniting-oltp-analytics-and-ai-workloads-on-postgresql-d3xypxemt)