Popular Clickhouse Articles

Most Popular Clickhouse Articles

Lead Lookup System Design (case study)

This case study explains how to design a high-scale lead lookup system for 200M users, where the main requirement is fast lookup by phone number, email address, or SSN while still supporting contact reassignment and full contact history.

Jan 12 2 case-study postgresql clickhouse

ClickHouse: what is it and what is it for?

ClickHouse: what is it and what is it for?

ClickHouse is an open-source, column-oriented database management system designed for online analytical processing ( OLAP ).

Apr 06 1 clickhouse olap database

ClickHouse vs PostgreSQL: Real-World Query Performance at Billion-Row Scale

ClickHouse vs PostgreSQL: Real-World Query Performance at Billion-Row Scale

This benchmark compares PostgreSQL and ClickHouse using identical data and queries to evaluate performance in a read-heavy analytical workload.

Apr 05 1 clickhouse postgresql database

Filter articles