pgEdge ColdFront Unites AI, Analytical, and OLTP Workloads with S3-Compatible Object Storage

pgEdge, a prominent open-source enterprise Postgres company, has announced the release of ColdFront, a groundbreaking transparent data tiering solution designed for PostgreSQL. This new offering addresses the challenge of managing ever-growing datasets by automatically moving older, less frequently accessed data to more economical S3-compatible object storage solutions. This includes major cloud providers such as Amazon S3, Google Cloud Storage, and Azure Blob Storage (ADLS Gen2). The primary benefit is a substantial reduction in storage costs, potentially up to 90% compared to traditional SSD-backed PostgreSQL storage. A key differentiator of ColdFront is its ability to maintain full read and write access to the cold-tiered data without requiring any modifications to existing application code. This means that UPDATE and DELETE operations can still be performed on archived rows using the same SQL commands applications already utilize, bypassing the need for data rehydration. The system stores older data in Apache Iceberg in Parquet format, optimizing it for cost-efficiency and performance. For analytical queries on this cold data, ColdFront integrates the DuckDB vectorized columnar engine, ensuring rapid scan speeds. The solution is particularly advantageous for use cases involving SaaS and IoT time-series workloads, where applications generate vast amounts of data daily but only require the recent working set in hot storage. ColdFront automatically archives older partitions, drastically cutting storage costs while allowing historical trend queries to span both hot and cold tiers seamlessly. Furthermore, regulated industries with stringent long-term data retention mandates can benefit from the significant cost savings and simplified data management. ColdFront also enhances operational resilience and scalability. In a pgEdge Spock multi-master cluster, cold data residing on S3 is simultaneously accessible for both reads and writes from every node, providing a compelling scaling solution for high-throughput or high-availability requirements. The system intelligently replicates only the working set, querying full historical data from any node. It also supports automatic data dropping after a specified retention period and pre-creates future partitions, reducing manual intervention. ColdFront is open source under the PostgreSQL License and will be integrated into pgEdge Enterprise Postgres and pgEdge Cloud in the second half of 2026.