pgEdge has launched ColdFront, an open-source tool that moves cold Postgres data to cheap storage while keeping it fully writable without changing your app code.
pgEdge, the open source enterprise Postgres company, announced pgEdge ColdFront on June 18, 2026. ColdFront is a data tiering solution for PostgreSQL that includes a fully writable cold tier: UPDATE and DELETE statements work on archived rows through the exact same SQL the application already uses, requiring no code changes and no data rehydration.
ColdFront automates partition management using simple time parameters, allowing seamless, non-blocking upgrades from standard PostgreSQL to full cold data tiering. Operating on standard PostgreSQL and Apache Iceberg, ColdFront eliminates vendor lock-in by keeping data open and fully compatible with existing analytical tools.
“ColdFront finally delivers for Postgres, without trade-offs and without proprietary vendor lock-in,” said Phillip Merrick, CPO of pgEdge. “The application keeps the same SQL. DuckDB runs in-process for analytical speed on cold data. The cold tier is writable. And it runs on standard unpatched PostgreSQL, so no migrations are required to deploy it.”
The company claims up to a 90% storage cost reduction and less complex operations for cold data, while delivering 10x to 100x faster analytical performance. Hot data replicates via pgEdge Spock, while cold data lives in shared object storage, meaning clusters replicate only the active working dataset while remaining able to query the full history from any node.
“Database teams are paying SSD prices for data they almost never touch, while spending real engineering time managing what to keep, what to delete, and how to recover old data when the business needs it,” said Dave Page, CTO of pgEdge.
“ColdFront handles the full lifecycle automatically. The application keeps using the same SQL, and the storage bill drops by up to 90%. We validated it at 4.4M rows per second across a 6-node cluster with 60 million rows. That is what production actually looks like.” ColdFront is available now as a beta release for pre-production testing and evaluation.
