# PostgreSQL + ClickHouse as the Open Source unified data stack

DevFeed: [PostgreSQL + ClickHouse as the Open Source unified data stack](<https://devfeed.tech/articles/postgresql-clickhouse-as-the-open-source-unified-data-stack-5511.md>)

Original publisher: [Read original article](<https://clickhouse.com/blog/postgres-clickhouse-oss>)

Author: Lionel Palacin

Published: 2026-01-27T00:00:00Z

Content type: article

Language: en

Sources: [ClickHouse Blog](<https://devfeed.tech/sources/clickhouse-blog.md>)

Topics: [clickhouse](<https://devfeed.tech/topics/clickhouse.md>), [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [Open Source](<https://devfeed.tech/topics/open-source.md>), [data](<https://devfeed.tech/topics/data.md>), [real-time](<https://devfeed.tech/topics/real-time.md>), [Streams](<https://devfeed.tech/topics/streams.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [GitHub](<https://devfeed.tech/topics/github.md>)

Tags: [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [data](<https://devfeed.tech/tags/data.md>), [github](<https://devfeed.tech/tags/github.md>), [open-source](<https://devfeed.tech/tags/open-source.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [real-time](<https://devfeed.tech/tags/real-time.md>), [sql](<https://devfeed.tech/tags/sql.md>), [streams](<https://devfeed.tech/tags/streams.md>), [systems](<https://devfeed.tech/tags/systems.md>)

## AI overview

This article presents an open source unified data stack that combines PostgreSQL for transactional workloads with ClickHouse for analytics at scale. It explains how components such as PeerDB and pg_clickhouse enable data replication and direct analytical queries without rewriting applications or SQL.

## Source excerpt

A ready-to-use open source data stack that combines PostgreSQL and ClickHouse to handle transactional and analytical workloads.