database-internals

作者对比了股票分析项目从基于 InnoDB 的 OLTP 架构迁移到基于 Iceberg 的 OLAP 湖仓栈的过程，深入讲解了 InnoDB 的行存储、索引 B-tree、undo log 与 MVCC 等内部机制，以及 Iceberg 如何帮助优化分析型负载。

The article provides a byte-by-byte analysis of PostgreSQL's VACUUM process at the page level, using pageinspect to show how dead tuple space is reclaimed.

A technical article exploring PostgreSQL internals, covering the logical and physical structure of database clusters, databases, tables, system catalogs, and object identifiers (OIDs).

A deep dive into how VictoriaLogs stores logs in a columnar layout, covering ingestion, stream identity, and compression.