18 ms·
Postgres is missing a proper columnstore implementation. It's a big gap and it's not easy to build. One solution could be integrating duckdb in a similar way a
by nikita 2y ago
Postgres is missing a proper columnstore implementation. It's a big gap and it's not easy to build.
One solution could be integrating duckdb in a similar way as pgvector. You need to map duckdb storage to Postgres storage and reuse duckdb query processor. I believe it's the fastest way to get Postgres to have competitive columnstores.
- smythe123 2y agoOlo, CEO of https://www.tablespace.io https://www.tablespace.io here. We've built a columnstore extension for Postgres that is faster than ClikcHouse for real-time analytics in their own ClickBench Benchmarks. Feel free to check it out - https://www.tablespace.io/blog/postgres-columnstore-index-vs-clickhouse https://www.tablespace.io/blog/postgres-columnstore-index-vs...
- tarasglek 2y agoThis sounds interesting. I don't see duck db as a supported extension or mentioned anywhere in your code yet ;) Is this foreshadowing?
- anentropic 2y agoHydra?