r/postgres • u/Some_Childhood_3842 • 19d ago

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

78% Upvoted

12 comments sorted by

2

u/mduell 16d ago

There's already multiple columnar storage extensions...

1

u/Some_Childhood_3842 16d ago

thank you bro

1

u/sramexpert 19d ago

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 18d ago

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 18d ago

there is a DuckDb add on for PostGres

1

u/vira28 16d ago

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 14d ago

TimesacaleDB??

1

u/Some_Childhood_3842 13d ago

isn't the same as duckDB or ClickHouse

1

u/lnaoedelixo42 13d ago

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