ClickHouse Acquires PeerDB

#1

Post by mebcitto » Tue, Jul 30, 2024, 3:54 PM UTC

ClickHouse Acquires PeerDB
clickhouse.com

Re: ClickHouse Acquires PeerDB

#2

Post by smythe123 » Tue, Jul 30, 2024, 4:08 PM UTC

Great exit for the PeerDB team, congratulations. However Postgres has improved so much over the years that many users don't need to move their data out of Postgres to get great performance for analytical queries.

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.

Re: ClickHouse Acquires PeerDB

#3

Post by saisrirampur » Tue, Jul 30, 2024, 4:27 PM UTC

smythe123 wrote: post #2

Great exit for the PeerDB team, congratulations. However Postgres has improved so much over the years that many users don't need to move their data out of Postgres to get great performance for analytical queries. 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 m…

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

Re: ClickHouse Acquires PeerDB

#4

Post by ryadh » Tue, Jul 30, 2024, 4:34 PM UTC

smythe123 wrote: post #2

Great exit for the PeerDB team, congratulations. However Postgres has improved so much over the years that many users don't need to move their data out of Postgres to get great performance for analytical queries. 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 m…

Congrats on Tablespace! it's good to see innovation in that space and I always love to see ClickBench mentioned in the wild :) (I work for ClickHouse).

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?

Re: ClickHouse Acquires PeerDB

#5

Post by dang » Tue, Jul 30, 2024, 6:35 PM UTC

smythe123 wrote: post #2

Great exit for the PeerDB team, congratulations. However Postgres has improved so much over the years that many users don't need to move their data out of Postgres to get great performance for analytical queries. 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 m…

Please don't copy-paste comments. It makes merging threads a pain.

Probably best not to do marketing on top of someone else's announcement too... https://x.com/mitchellh/status/1759626842817069290?t=57h-biZ...