Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Load Test GlassFlow for ClickHouse: Real-Time Dedup at Scale

glassflow.dev

Post reply on HN
Print view View original

1–10 of 11 posts

Re: Load Test GlassFlow for ClickHouse: Real-Time Dedup at Scale

#2

Post by super_ar »

Hi HN, A few weeks ago, we shared GlassFlow: Open Source streaming ETL to dedup and join streams from Kafka for ClickHouse (https://news.ycombinator.com/item?id=43953722).

One of the top questions we received was: “How well does it perform at high throughput?”

We ran a load test and would like to share some results with you.

Summary of the test:

- Tested on 20m records

- Kafka produced 55,000 records/sec

- Processing rate of GlassFlow (deduplication): 9,000+ records/sec

- Measured on a MacBook Pro (M3 Max)

- End-to-end latency: Here is the blog post with full test results and tried with different parameters (rps, # of publishers, etc.): https://www.glassflow.dev/blog/load-test-glass-flow-for-clic...

It was important to us to set up the testing in a way that everybody could reproduce. Here are the docs: https://docs.glassflow.dev/load-test/setup

We would love to get feedback, especially from folks consuming high-throughput in ClickHouse.

Thanks for reading!

Ashish and Armend (founders)

Re: Load Test GlassFlow for ClickHouse: Real-Time Dedup at Scale

#3

Post by api »

Unless I’m missing some big numbers somewhere you could do that locally on a pi 5 with efficient code. Nothing heroic required, just a decently fast language like Go.

My laptop can run 70B LLMs at usable speeds.

I know. Doesn’t scale. No redundancy. No auto redeploy on failures. This is what I mean.

Do we really have to sacrifice this much efficiency for those things or are we doing it wrong? Does the ability to redeploy on failures, cluster, and scale really require order of magnitude performance penalties across the whole stack?

Re: Load Test GlassFlow for ClickHouse: Real-Time Dedup at Scale

#4

Post by super_ar »

api wrote: post #3

Unless I’m missing some big numbers somewhere you could do that locally on a pi 5 with efficient code. Nothing heroic required, just a decently fast language like Go. My laptop can run 70B LLMs at usable speeds. I know. Doesn’t scale. No redundancy. No auto redeploy on failures. This is what I mean. Do we really have to sacrifice this much efficiency for those things or are we doing it wrong? Does the ability to rede…

Totally fair point. For stable, known workloads, you can get really far with something lightweight on a single machine. The challenge comes when you need fault tolerance, scaling, and delivery guarantees without constantly jumping in to fix things. Often heard from data teams talking about data peaks that they cannot predict as easily. But yes, a lot of existing tools make you pay a high-efficiency cost for that. At GlassFlow we are trying to hit that sweet spot...efficient but still resilient.

Re: Load Test GlassFlow for ClickHouse: Real-Time Dedup at Scale

#5

Post by CaveTech »

super_ar wrote: post #4
api wrote: post #3

Unless I’m missing some big numbers somewhere you could do that locally on a pi 5 with efficient code. Nothing heroic required, just a decently fast language like Go. My laptop can run 70B LLMs at usable speeds. I know. Doesn’t scale. No redundancy. No auto redeploy on failures. This is what I mean. Do we really have to sacrifice this much efficiency for those things or are we doing it wrong? Does the ability to rede…

Totally fair point. For stable, known workloads, you can get really far with something lightweight on a single machine. The challenge comes when you need fault tolerance, scaling, and delivery guarantees without constantly jumping in to fix things. Often heard from data teams talking about data peaks that they cannot predict as easily. But yes, a lot of existing tools make you pay a high-efficiency cost for that. At…

I think your benchmark may miss the mark a bit if this is your angle.

20m records and 9k/sec isn’t very impressive. I would imagine most prospective customers have larger workloads, as you could throw this behind Postgres and call it a day. FWIW I was interested but your metrics made me second guess and wonder what was wrong.

Re: Load Test GlassFlow for ClickHouse: Real-Time Dedup at Scale

#7

Post by super_ar »

CaveTech wrote: post #5
super_ar wrote: post #4

Earlier quoted context omitted.

Totally fair point. For stable, known workloads, you can get really far with something lightweight on a single machine. The challenge comes when you need fault tolerance, scaling, and delivery guarantees without constantly jumping in to fix things. Often heard from data teams talking about data peaks that they cannot predict as easily. But yes, a lot of existing tools make you pay a high-efficiency cost for that. At…

I think your benchmark may miss the mark a bit if this is your angle. 20m records and 9k/sec isn’t very impressive. I would imagine most prospective customers have larger workloads, as you could throw this behind Postgres and call it a day. FWIW I was interested but your metrics made me second guess and wonder what was wrong.

Fair point. Thanks for calling it out! To clarify, we’re focused on a specific use case: Kafka to ClickHouse pipelines with exactly-once guarantees. Kafka can’t provide exactly-once out of the box when writing to external systems like ClickHouse. You could use something like Flink, but there’s no native Flink-to-ClickHouse connector and Flink requires certain ops effort from the teams. Our goal was to show users a very easy-to-reproduce load test to validate the results. As a next step, we’re actively working on a Kubernetes-ready version that will scale horizontally and plan to share those higher-throughput results with the HN community soon.

Re: Load Test GlassFlow for ClickHouse: Real-Time Dedup at Scale

#8

Post by super_ar »

kI3RO wrote: post #6

That site has no scrollbars so I can't read it. Any alternative?

There is another test that we published on our docs page. You can check it out here:

Setup: https://docs.glassflow.dev/load-test/setup

Results: https://docs.glassflow.dev/load-test/results

Re: Load Test GlassFlow for ClickHouse: Real-Time Dedup at Scale

#9

Post by secondcoming »

super_ar wrote: post #2

Hi HN, A few weeks ago, we shared GlassFlow: Open Source streaming ETL to dedup and join streams from Kafka for ClickHouse ( https://news.ycombinator.com/item?id=43953722 ). One of the top questions we received was: “How well does it perform at high throughput?” We ran a load test and would like to share some results with you. Summary of the test: - Tested on 20m records - Kafka produced 55,000 records/sec - Processi…

> - Measured on a MacBook Pro (M3 Max)

Everything was running on the same machine?

Re: Load Test GlassFlow for ClickHouse: Real-Time Dedup at Scale

#10

Post by super_ar »

secondcoming wrote: post #9
super_ar wrote: post #2

Hi HN, A few weeks ago, we shared GlassFlow: Open Source streaming ETL to dedup and join streams from Kafka for ClickHouse ( https://news.ycombinator.com/item?id=43953722 ). One of the top questions we received was: “How well does it perform at high throughput?” We ran a load test and would like to share some results with you. Summary of the test: - Tested on 20m records - Kafka produced 55,000 records/sec - Processi…

> - Measured on a MacBook Pro (M3 Max) Everything was running on the same machine?

Yes, same machine.
Post reply on HN