Latest ClickHouse Articles

Recently added ClickHouse Articles

Interested in clickhouse articles?

Subscribe and don’t miss new content.

Sign in to subscribe

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 ).

5.0/5 (2)

Oleksandr Andrushchenko Apr 06 2

clickhouse olap databases

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.

5.0/5 (1)

Oleksandr Andrushchenko Apr 05 1

clickhouse postgresql databases

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.

5.0/5 (2)

Jan 12 2

case-study postgresql clickhouse