From OLTP to OLAP: Is PostgreSQL Eating Analytics Too?
Session Abstract
Can PostgreSQL become a serious analytics engine? With emerging columnar extensions, PostgreSQL is pushing beyond OLTP into OLAP territory. This talk explores the current columnar landscape, architectural trade-offs, and how far PostgreSQL can go compared to analytical engines like ClickHouse.
Session Description
Traditionally a row-oriented OLTP system, PostgreSQL is now gaining columnar capabilities through extensions such as Citues, TigerData columnar, pg_duckdb and more built on PostgreSQL’s pluggable storage layer. This raises a serious architectural question: can PostgreSQL evolve into a competitive analytical engine?
In this talk, we provide a structured overview of the current PostgreSQL columnar ecosystem — how these extensions work, what features they offer, and where they differ in terms of compression, execution model, and performance.
We place these developments in the broader context of modern database trends: HTAP ambitions, consolidation of data stacks, and the gravitational pull of PostgreSQL as a platform.
Finally, we discuss selected performance observations and architectural considerations when comparing columnar PostgreSQL setups to established analytical systems such as ClickHouse from a technical exploration of trade-offs.
Is PostgreSQL becoming a universal data platform, or are there structural limits to how far columnar extensions can take it?
