Postgres continues to serve transactional workloads, ClickHouse handles analytics and an ecosystem has developed that brings them closer together.

The New Stack is a publication covering trends and technologies in cloud-native development, DevOps, and software delivery. Developers can learn about containerization, Kubernetes, and cloud computing, as well as explore topics such as microservices architecture, serverless computing, and continuous integration/continuous delivery (CI/CD) pipelines.

The New Stack

AI-driven workloads are pushing applications to scale faster, exposing PostgreSQL's limitations for analytical queries much sooner than before. A proven architectural pattern combines Postgres for transactional workloads with ClickHouse for analytics. Data integration happens through split/dual-write patterns or CDC streaming, while application integration uses native clients or foreign data wrappers. An open source ecosystem including PeerDB, PostgreSQL FDWs, and tools like MooseStack makes this architecture production-ready. As scaling timelines compress, starting with both databases from the beginning is becoming more practical.

Postgres + ClickHouse: The OSS Stack To Handle Agentic AI Scale