Posts

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.

PostgreSQL Summit Chengdu 2023 — A look back at transaction isolation level evolution and PostgreSQL's Serializable Snapshot Isolation implementation

A mid-2023 rundown of American TV shows I've watched, centered around the Yellowstone series, 1923, 1883, and others — with impressions, personal ratings, and recommendations.