[saisrirampur]

Thanks for posting this question! I previously worked at Citus for 8 years, where we tried to bring real-time analytical capabilities to Postgres. It was common to see POCs go sideways, and several customers (including CloudFlare and Heap) moved from Citus to an analytics-specialized database. For example, CloudFlare moved from Citus to ClickHouse. This was one of the inspirations for me to build a company (PeerDB) that brings specialized OLTP and OLAP databases together.

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. :)