Tag: #olap
Writing on GPUs, LLMs, MLOps, Kubernetes — and mindset · 13 posts
The 300x Is Not a Number You Get by Tuning PostgreSQL — The Volcano Model and Vectorized Execution
A precise dissection of the 300x published alongside the pgrust 0.2 release. That figure did not come from changing a PostgreSQL setting; it is a ClickBench measurement of a database newly implemented in Rust, while the
2026-08-09 · 9 min read #postgresql#database#performance#query-engine#simdClickHouse Lazy Materialization — How a LIMIT 10 Trick Grew Into FINAL and JOIN
ClickHouse's lazy materialization is an optimization that skips reading SELECT columns until sorting and LIMIT are finished, and it launched in 25.4 (April 2025) as a conservative feature that only kicked in for LIMIT 10
2026-07-17 · 15 min read #database#clickhouse#olap#query-optimization#performanceDuckDB Gets a Client-Server Protocol — What Quack Changes and What It Doesn't
On May 12, 2026, the DuckDB team announced Quack — a client-server protocol built on top of HTTP that lets two DuckDB instances become client and server to each other, so the same database can be read and written concurr
2026-07-16 · 18 min read #database#duckdb#olap#analytics#data-engineeringDuckDB in Practice — The Era of Embedded Analytics That Ends on Your Laptop
Why is DuckDB, often called the SQLite of OLAP, so loved? We start from the architecture and cover direct Parquet querying, hands-on examples of window functions, PIVOT, and ASOF JOIN, zero-copy integration with pandas,
2026-06-12 · 14 min read #duckdb#database#olap#analytics#parquetModern Cloud Data Warehouses 2026 Deep Dive - Snowflake, Databricks SQL, BigQuery, Redshift, Firebolt, Azure Synapse, MotherDuck
A May 2026 survey of the modern cloud data warehouse landscape. Covers Snowflake, Databricks SQL, Google BigQuery, AWS Redshift Serverless, Azure Synapse, Firebolt, MotherDuck, DuckDB, ClickHouse Cloud, StarRocks, Apache
2026-05-16 · 28 min read #data-warehouse#snowflake#databricks#bigquery#redshiftDatabase Engines 2026 Deep-Dive — Postgres Won the API, ClickHouse and DuckDB Won Analytics
PostgreSQL 17/18, MySQL 9, MariaDB 12, SQLite + libSQL + Turso, DuckDB 1.x, ClickHouse, StarRocks, Doris, Druid, Pinot, TiDB, CockroachDB 25, YugabyteDB, Cassandra 5, ScyllaDB, Aerospike, Neon, Supabase, PlanetScale, Xat
2026-05-16 · 17 min read #database#postgresql#mysql#clickhouse#duckdbOLAP Engines 2025 Comparison Guide: DuckDB, ClickHouse, Snowflake, StarRocks, Pinot, Druid, Trino, Benchmark Traps, Engine Placement (2025)
Season 5 Ep 3. No single engine covers all of OLAP. DuckDB brings the single-node revolution, ClickHouse handles real-time OLAP, Snowflake and BigQuery offer managed convenience, StarRocks, Doris, Pinot and Druid take on
2026-04-15 · 12 min read #olap#duckdb#clickhouse#snowflake#bigqueryDuckDB Internals Deep Dive — Embedded OLAP, Vectorized Execution, Morsel-Driven Parallelism, and Storage Format (2025)
DuckDB — the analytical engine that replaces Pandas and brings a ClickHouse-class OLAP database into your process. This post dissects DuckDB from the ground up: the journey from Mark Raasveldt and Hannes Mühleisens 2018
2026-04-15 · 24 min read #duckdb#olap#database#columnar#vectorizationClickHouse Internals Deep Dive — MergeTree, Vectorized Execution, Distributed Queries, Keeper (2025)
The analytics engine behind Cloudflare, Uber, Bloomberg, and Yandex — processing tens of trillions of rows daily. This post dissects ClickHouse from the ground up: columnar vs row storage, the MergeTree family (Replacing
2026-04-15 · 15 min read #clickhouse#olap#columnar#mergetree#analyticsClickHouse MergeTree — The Complete Guide to Columnar, Sparse Index, Part, and Materialized View (2025)
Everything about ClickHouse MergeTree — the physical layout of columnar storage, parts and granules and the sparse primary index, why ORDER BY matters so much, projections and skip indexes, real-time aggregation with mat
2026-04-15 · 23 min read #clickhouse#olap#columnar#mergetree#analyticsDuckDB In-Memory Analytics and OLAP Guide
A guide to DuckDB in-memory analytics for OLAP workloads, covering query optimization, data formats, and integration patterns.
2026-03-15 · 28 min read #database#duckdb#olap#analytics#in-memoryDuckDB OLAP Analytics and Data Lake Guide
A guide to using DuckDB for OLAP analytics and data lake querying, covering in-process analytics, Parquet integration, and performance optimization.
2026-03-08 · 22 min read #database#duckdb#olap#analytics#data-lakeClickHouse Real-time OLAP and MergeTree Optimization Guide
A practical guide to ClickHouse real-time OLAP analytics and MergeTree engine optimization for high-performance analytical workloads.
2026-03-06 · 21 min read #database#clickhouse#olap#mergetree#real-time-analytics