Cogent Security built an AI-native vulnerability management platform on ClickHouse, migrating from Postgres to achieve sub-second query latency on hundreds of millions of rows without caching. The architecture uses a hot/cold data lakehouse with Iceberg on S3 and ClickHouse as the serving layer, with denormalized tables,
Table of contents
The growing threat gap #Security data at scale #Designing for speed #Sub-second performance #Making reporting conversational #Iterating toward accuracy #One source of truth #A virtuous cycle #Sort: