Home / Companies / ClickHouse / Blog / Post Details
Content Deep Dive

“Like night and day”: How Auditzy made queries 33x faster by switching from Postgres to ClickHouse

Blog post from ClickHouse

Post Details
Company
Date Published
Author
Mayank Joshi, Co-Founder and CTO, Auditzy
Word Count
1,245
Company Posts That Month
21
Language
English
Hacker News Points
-
Post removed?
No
Summary

Auditzy, a company founded in Mumbai in 2022, focuses on converting user interaction data from websites into actionable insights for various business teams, addressing both performance optimization and business impact. Initially, Auditzy's architecture using Postgres struggled with scalability and performance issues, such as query latency and complex maintenance tasks. In response, they transitioned to ClickHouse in 2023, following a successful proof of concept that demonstrated significant improvements in query speed, storage efficiency, and reduced technical debt. This shift allowed Auditzy to streamline operations and focus on new features, such as the Auditzy Copilot, which uses ClickHouse and LLMs to provide real-time, conversational analytics for users across an organization. The move to ClickHouse has not only enhanced the user experience and developer efficiency but also positioned Auditzy to innovate further in delivering dynamic and accessible analytics solutions.

Trends Found in this Post
Trend Post Mentions Total Month Mentions Posts Companies MoM
Real-time 6 7,098 1,366 278 +45%
AI Coding Assistant 1 1,047 225 104 -16%
Developer Experience 1 814 330 125 +41%
LLM 1 4,795 798 241 +9%
MCP 1 5,213 426 153 +44%
Use This Data

Use this post, company, and trend context to find content marketing opportunities, perform competitive analysis, or address product feature gaps via the Plushcap MCP server or the Plushcap API.