Fast, scalable, enterprise-grade Postgres natively integrated with ClickHouse
Blog post from ClickHouse
A new enterprise-grade managed Postgres service integrated with ClickHouse has been announced, designed to support real-time and AI-driven applications by unifying transactional and analytical workloads without traditional complexity. This service leverages the strengths of Postgres for transactions and ClickHouse for analytics, providing a scalable, high-performance solution with reduced operational overhead. Developers benefit from a Postgres service backed by local NVMe storage, which offers significantly faster performance for disk-bound workloads, and native CDC capabilities for syncing transactional data to ClickHouse for analytics. The unified query layer, powered by the pg_clickhouse extension, allows seamless application development that spans both transactions and analytics. The collaboration with Ubicloud ensures a high standard of performance and scalability, making the service suitable for AI-driven companies that face challenges with disk IOPS and latency. The integration also includes robust features like high availability, automatic backups, and open-source components, ensuring transparency and long-term flexibility. The service is available for private preview, initially offered on AWS with plans to expand to other cloud providers.