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

DevFeed: ["Like night and day": How Auditzy made queries 33x faster by switching from Postgres to ClickHouse](<https://devfeed.tech/articles/like-night-and-day-how-auditzy-made-queries-33x-faster-by-switching-from-postgres-to-clickhouse-4969.md>)

Original publisher: [Read original article](<https://clickhouse.com/blog/auditzy-33x-faster-clickhouse-vs-postgres>)

Author: Mayank Joshi, Co-Founder and CTO, Auditzy

Published: 2025-10-09T00:00:00Z

Content type: article

Language: en

Sources: [ClickHouse Blog](<https://devfeed.tech/sources/clickhouse-blog.md>)

Topics: [clickhouse](<https://devfeed.tech/topics/clickhouse.md>), [data-architecture](<https://devfeed.tech/topics/data-architecture.md>), [Latency](<https://devfeed.tech/topics/latency.md>), [Back end](<https://devfeed.tech/topics/backend.md>), [data](<https://devfeed.tech/topics/data.md>), [real-time](<https://devfeed.tech/topics/real-time.md>), [datasets](<https://devfeed.tech/topics/datasets.md>), [Amazon Web Services](<https://devfeed.tech/topics/aws.md>), [Azure](<https://devfeed.tech/topics/azure.md>), [browser](<https://devfeed.tech/topics/browser.md>), [Operating system](<https://devfeed.tech/topics/operating-system.md>)

Tags: [architecture](<https://devfeed.tech/tags/architecture.md>), [aws](<https://devfeed.tech/tags/aws.md>), [azure](<https://devfeed.tech/tags/azure.md>), [backend](<https://devfeed.tech/tags/backend.md>), [browser](<https://devfeed.tech/tags/browser.md>), [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [compression](<https://devfeed.tech/tags/compression.md>), [data](<https://devfeed.tech/tags/data.md>), [data-architecture](<https://devfeed.tech/tags/data-architecture.md>), [datasets](<https://devfeed.tech/tags/datasets.md>), [geolocation](<https://devfeed.tech/tags/geolocation.md>), [golang](<https://devfeed.tech/tags/golang.md>), [india](<https://devfeed.tech/tags/india.md>), [latency](<https://devfeed.tech/tags/latency.md>), [metrics](<https://devfeed.tech/tags/metrics.md>), [performance](<https://devfeed.tech/tags/performance.md>), [postgres](<https://devfeed.tech/tags/postgres.md>), [real-time](<https://devfeed.tech/tags/real-time.md>), [scalable-architecture](<https://devfeed.tech/tags/scalable-architecture.md>), [switching](<https://devfeed.tech/tags/switching.md>)

## AI overview

Auditzy migrated from a Postgres-based architecture to ClickHouse after query latency and ingestion problems emerged as data volumes grew. The migration delivered queries that were 33x faster and 10x better compression, supporting scalable, real-time website performance analytics.

## Source excerpt

When Mumbai-based startup Auditzy hit Postgres performance limits, they switched to ClickHouse--and saw queries run 33x faster with 10x better compression.