ClickHouse columnar storage, the MergeTree engine family, primary key vs sorting key, materialized views for pre-aggregation, query profiling with EXPLAIN, replication with ClickHouse Keeper, distributed tables for sharding, and when to choose ClickHouse over PostgreSQL.
Olap
-
ClickHouse for Analytics Workloads -
DuckDB for Analytics Engineers: In-Process OLAP That Replaces Your Spark Cluster A comprehensive guide to DuckDB—covering its columnar vectorized execution engine, querying Parquet and S3 directly, replacing heavy Spark jobs for medium data workloads, Python and R integration, performance tuning, and when to use DuckDB vs alternatives.