At Tablespace https://www.tablespace.io we've built a ColumnStore Index natively as a Postgres extension that enables users to execute analytical queries in Postgres 2X faster than Clickhouse Cloud without moving their data https://www.tablespace.io/blog/postgres-columnstore-index-vs...
For transparency I'm the CEO of Tablespace.
This is not to say that Postgres cannot support larger-scale analytical workloads, but it will take time. ClickHouse has taken 10 years of effort and development to get where it is now.
I would love to understand how tablespace performs at scale in production workloads. Are there any references that you could share. :)
Probably best not to do marketing on top of someone else's announcement too... https://x.com/mitchellh/status/1759626842817069290?t=57h-biZ...
I'm curious to hear your take about the tradeoffs that the HTAP model introduces? any impact on ingest times or query throughput for example?