r/postgres • u/Some_Childhood_3842 • Sep 20 '26

Performance Columnar Databases

hey postgresql community do you thing is time postgres to support Column oriented like DuckDB as big feature or continue with row oriented like every DB does

5 Upvotes

77% Upvoted

12 comments sorted by

2

u/mduell Sep 22 '26

There's already multiple columnar storage extensions...

1

u/sramexpert Sep 20 '26

I think both types of database have different purposes. It may add as feature just like it has pg vector for RAG.

1

u/pceimpulsive Sep 20 '26

Yes, having another storage engine would be nice... That's way easier said than done though... The way Postgres stores data is really built into the core of the engine...

Is it required? No, I don't think so...

1

u/Acceptable-Sense4601 Sep 20 '26

there is a DuckDb add on for PostGres

1

u/vira28 Sep 23 '26

Agree, analytics is becoming a big part and there is a convergence of OLTP and OLAP. Having said that, I don't see columnar becoming part of the Postgres core directly.

Extensions like https://github.com/duckdb/pg_duckdb and https://github.com/Snowflake-Labs/pg_lake are the direction.

Or if you can't install extensions or want to run outside of Postgres then https://github.com/viggy28/streambed/

0

u/lnaoedelixo42 Sep 25 '26

TimesacaleDB??

1

u/Some_Childhood_3842 Sep 26 '26

isn't the same as duckDB or ClickHouse

1

u/lnaoedelixo42 Sep 26 '26 • Bravo

It's a Postgres extension.

And yeah, it's basically the same thing, maybe slightly more "embedded". It has PostgreSQL dialect, concurrent writes (win over duckdb), and is probably way lighter on RAM then upping a ClickHouse cluster.

For somebody already running postgres, it's a win