#general

ClickHouse vs Elasticsearch for Small-Scale Applications

TLDR Matt asked if ClickHouse is a better alternative than Elasticsearch for small-scale applications. Ankit shared a link and asked about the scale Matt was working with.

7mo

Join the chat

Feb 17, 2023 (7 months ago)

Photo of md5-1c2b014c9d4185f45dd3e08b55130ccb

Matt

03:23 PM

Sorry, I had another question to add to my question above. I understand that SigNoz uses ClickHouse, a columnar database. From what I understand, columnar databases like ClickHouse are better than say Elasticsearch for observability data. But I also have only come across use cases where the performance difference happens at a large enough scale (e.g. Uber and Cloudflare). I'm wondering if ClickHouse is still a better alternative than Elasticsearch for small-scale applications, and if so, why?

Photo of md5-dbe7088320fe1d922707613e02f3420d

Ankit

03:39 PM

I do not see 500GB of data as large https://signoz.io/blog/logs-performance-benchmark/

03:40

Ankit

03:40 PM

what is the scale that you work with? Matt

Matt

06:31 PM

Thanks for your response Ankit. I'm new to all this and am justing doing research for a school project so I'm not really working with any scale. I just want to know if the performance advantage that ClickHouse offers only happens at the scale of an Uber or CloudFlare. Thanks for the link also, I'll take a look.

SigNoz Community

Built with ClickHouse as datastore, SigNoz is an open-source APM to help you find issues in your deployed applications & solve them quickly | Knowledge Base powered by Struct.AI

Indexed 825 threads (61% resolved)

Join Our Community Manage subscription

Similar Threads

Configuring ClickHouse for S3 Retention and EC2 Deployment

sarthak asks about configuring S3 data retention and if ClickHouse documentation is enough. vishal-signoz shares guide links and confirms ClickHouse will query S3 data, SigNoz handles everything, and using EC2 with vertical scaling is fine for their use case.

4mo

CPU Imbalance in Clickhouse Clustered with SigNoz

Nick experienced CPU imbalance in a 3-node Clickhouse cluster for SigNoz. Srikanth provided insights on schema and operations, and the issue resolved after 2 weeks due to data expiration.

6mo

Services UI Goes Blank Due to Retention Issue with S3 Bucket

oluchi reports issue with services UI going blank after a while. Conversation explores possible reasons, such as S3 connection problems and disk space, but no resolution is reached.

4mo