Scaling SaaS security: Reco’s migration from Postgres to ClickHouse Cloud

Reco, an AI-driven SaaS security solution, focuses on securing enterprises by delving into SaaS applications where employees operate, supporting over 215 integrations and capable of discovering more than 60,000 applications. Initially reliant on Postgres, Reco switched to ClickHouse Cloud to manage its vast data processing needs, ingesting billions of events weekly and handling extensive row reads and writes. The transition to ClickHouse was driven by the need for faster, scalable processing, as Postgres struggled with the volume and complexity of Reco's operations. Despite not being ACID compliant, ClickHouse offered the relational-style functionality required, with advantages such as incremental materialized views, efficient joins, and data-skipping indexes, which improved performance and reduced costs. Additionally, Reco creatively employed ClickHouse as a state store for streaming workloads, overcoming earlier memory and synchronization challenges with Spark and Redis. The switch to ClickHouse Cloud has markedly enhanced Reco's platform, reducing costs, increasing speed, and allowing for significant customer base growth.