# Clickhouse
4 posts- How Sentry queries unstructured data in ClickHouse 62x fasterdate: author: Colin Chartier
We repurposed a hashtable to make ClickHouse significantly faster for analytical queries
- Lost in the Haystack: Optimizing an Expensive ClickHouse Querydate: author: Colton Allen
Finding a needle in a haystack is really difficult. Why make it harder than it needs to be?
- How to Mutate Data in a System Designed for Immutable Datadate: author: Filippo Pacifici
Sentry’s growth led to increased write and read load on our databases, and, even after countless rounds of query and index optimizations, we felt that our databases were always a hair’s breadth from the next performan...
- Introducing Snuba: Sentry's New Search Infrastructuredate: author: Sentry Engineer
For most of 2018, we worked on an overhaul of our underlying event storage system. We’d like to introduce you to the result of this work — Snuba, the primary storage and query service for event data that powers Sentry...