BestHub
Sign in
Tagged articles

Distributed Tables

6 articles · Page 1 of 1
ITPUB
ITPUB
May 21, 2024 · Databases

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.

ClickHouseDistributed TablesLocal Tables
0 likes · 13 min read
Can ClickHouse Distributed Tables Outperform Single-Node Tables? A Real-World Benchmark
Hacker Afternoon Tea
Hacker Afternoon Tea
May 27, 2022 · Databases

Exploring Citus 11.x Utility Functions for Distributed PostgreSQL

This article provides a comprehensive reference of Citus‑provided user‑defined functions—including table DDL, metadata management, cluster maintenance, and shard rebalancing utilities—detailing their purpose, required permissions, parameters, and behavior within a distributed PostgreSQL environment.

CitusCluster ManagementDistributed Tables
0 likes · 19 min read
Exploring Citus 11.x Utility Functions for Distributed PostgreSQL
Hacker Afternoon Tea
Hacker Afternoon Tea
Mar 24, 2022 · Databases

Quick Guide: Testing Citus Distributed PostgreSQL on Kubernetes with Distributed, Co‑located, Reference, and Columnar Tables

This tutorial walks through setting up a Citus‑enabled PostgreSQL cluster on Kubernetes, creating distributed tables, using co‑location and reference tables for high‑performance joins, and comparing row‑based versus columnar storage with concrete SQL commands and performance metrics.

CitusCo-locationDistributed Tables
0 likes · 11 min read
Quick Guide: Testing Citus Distributed PostgreSQL on Kubernetes with Distributed, Co‑located, Reference, and Columnar Tables
360 Zhihui Cloud Developer
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