Can ClickHouse Distributed Tables Outperform Single-Node Tables? A Real-World Benchmark

This article presents a systematic benchmark comparing ClickHouse local (single‑node) tables and distributed tables across three data volumes—≈60 billion, 5 billion and 50 million rows—using a variety of aggregation and filter queries, and reveals that distributed tables dominate at large scale while the gap narrows as the dataset shrinks.

Distributed TablesLocal Tablesbenchmark

0 likes · 13 min read

Can ClickHouse Distributed Tables Outperform Single-Node Tables? A Real-World Benchmark

Big Data Technology & Architecture

Mar 5, 2022 · Databases

Understanding ClickHouse Distributed Tables, Replication, and Sharding

This article explains the concepts of ClickHouse local and distributed tables, why writing directly to distributed tables can be problematic, and how replication, sharding, and the ReplicatedMergeTree engine work together with ZooKeeper to provide high‑availability and scalable query processing.

Big DataDatabase ArchitectureDistributed Tables

0 likes · 9 min read

Understanding ClickHouse Distributed Tables, Replication, and Sharding

360 Zhihui Cloud Developer

Mar 9, 2017 · Databases

Master Greenplum Table Design & Performance Optimization: Practical Tips

This article explains what Greenplum is, its MPP shared‑nothing architecture, and provides concrete table‑design principles, distribution‑column strategies, indexing guidance, vacuum and table‑rebuilding techniques, as well as SQL, join, insert, update/delete, and resource‑queue optimizations for better performance.

Database designDistributed TablesGreenplum

0 likes · 9 min read

Master Greenplum Table Design & Performance Optimization: Practical Tips