Hey team, we are evaluating Signoz opensource and have a few questions. After analyzing the code, it seems that postgres is only supported with the enterprise license https://github.com/SigNoz/signoz/tree/main/ee. So for opensource, is only sqlite supported? Does that mean the signoz server is not horizontally scalable, and thus we also can't really support running multiple instances across multi-region/multi-cloud? Also, how would highly available alerting work if there are multiple instances of signoz with a postgres DB? Is there some sort of deduplication of alert notifications?

I think this response is still relevant: > As of now SQLite is primarily used to store internal metadata like dashboards layout, alert config, etc The core data ingestion / query part of Signoz is built on Clickhouse which is where any concerns about horizontal scaling and multi region would live (and already addressed by Clickhouse).

Yeah makes sense, however if I am running signoz across multiple instances for HA, how does that handle alerting, dashboards, users, etc for the DB? We have tested this and run into split brain issues with sqlite

Ah right, the current approach does make assumptions about the frontend and QueryService never being bottlenecks.

Are there benchmarks about how high that can scale just vertically?

Oh yeah, that'd be a much bigger concern now that the services have been consolidated. I'm not aware of any benchmarks. Whoops, also not a Signoz employee, I just pop in here for discussions.

ah interesting, didn't realize they used to be microservices. Sounds good, thanks for the input though!