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?

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

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.