PostgreSQL Internals

A comprehensive guide to PostgreSQL declarative partitioning, partition maintenance strategies, and query optimization techniques.

A systematic deep dive into PostgreSQL localization mechanisms, covering locale, collation rules, character set principles, and their impact on query behavior.

An in-depth analysis of PostgreSQL's transaction mechanism and MVCC implementation, covering isolation levels, row-level locks, and multi-version concurrency control without undo.

A detailed explanation of PostgreSQL's shared memory architecture, covering shared_buffers, WAL buffer, CLOG buffer, and the Linux shared memory implementation mechanism.

In-depth analysis of PostgreSQL FDW (Foreign Data Wrapper) principles and usage, covering the SQL/MED standard, four FDW objects, and common FDW extensions

From physical memory to process address space, systematically organizing the core concepts and low-level principles of Linux memory management.