20 October 2026
50 new posts across 7 database and data engineering sources — 7 worth your time.
Álvaro Hernández: Open-source Citus matches PlanetScale's Neki at 10M QPS on half the data nodes
This post benchmarks open-source Citus against PlanetScale's published Neki benchmarks on distributed PostgreSQL workloads. It analyzes query throughput and node efficiency, demonstrating Citus achieving 10 million QPS on half the data nodes required by Neki.
Planet PostgreSQL · 20 October 2026 · Read the original →
What Is Inside an Iceberg Table?
The article unpacks the physical storage architecture of Apache Iceberg tables, detailing the role of top-level JSON metadata, mid-level Avro manifest files, and underlying Parquet data files. It demonstrates practical SQL techniques in DuckDB to directly query and inspect each layer of the Iceberg metadata tree when debugging query performance or state corruption.
DuckDB · 20 October 2026 · Read the original →
Hubert 'depesz' Lubaczewski: Old tech is sometimes better – a case study based on blogpost from Now-Next…
The post tests the operational tradeoffs of audit logging using PostgreSQL triggers by comparing full-row snapshot logs against diff-only column updates. Through practical experiments, it measures how storing only changed columns yields a 5x reduction in log table storage size at the cost of higher trigger CPU execution time.
Planet PostgreSQL · 20 October 2026 · Read the original →
Chris van Eijk: CREATE POLICY IF NOT EXISTS in PostgreSQL: what works
This piece explores how to execute idempotent Row Level Security (RLS) policy changes in PostgreSQL despite the lack of native CREATE POLICY IF NOT EXISTS syntax. It evaluates three migration patterns across PostgreSQL 17 and 18, analyzing lock acquisition, execution gaps, and race conditions.
Planet PostgreSQL · 20 October 2026 · Read the original →
How Ridgeline unified Iceberg and ClickHouse into one analytics layer for investment management
Ridgeline details its production architecture overhaul, pairing ClickHouse Cloud with historical data stored in Apache Iceberg tables. This hybrid setup allows fast point queries over recent data alongside cold analytics over decades of historical records, scaling the platform to support customers 10x larger than previous limits.
ClickHouse · 20 October 2026 · Read the original →
Sequences and other volatiles in Neki
This article examines the semantics and execution mechanics of sequence generators and volatile functions inside distributed SQL query planners like Neki. It delves into the trade-offs of handling side-effects and non-deterministic functions across sharded execution layers.
PlanetScale · 20 October 2026 · Read the original →
From JSON Strings to Typed Columns
The post explains how to apply dynamic JSON schema inference and row parsing to raw text columns already stored inside relational or file-based datasets. It details how DuckDB's read_json mechanics can be repurposed to process stringified event payloads into structured, typed relational columns.
DuckDB · 20 October 2026 · Read the original →
Eventually every modern architecture turns back into a relational database with extra steps.
7 stories, every Tuesday
Published here every week. Follow by RSS to get it as it lands.