Posts

Reading notes on Are We Smart Enough to Know How Smart Animals Are? — challenging the assumption of human uniqueness by revealing that tool use, language, cooperation, and more are not exclusively human, through primate behavior experiments

Reading notes on 2001: A Space Odyssey — marveling at Arthur C. Clarke's astonishingly prescient predictions from the 1960s, from AI to tablet computers, and the TMA-1 monolith as the core sci-fi conceit

Deep dive into a 5MB giant SQL with 5000+ UNION ALLs causing OOM at 70GB, exploring plan cache memory consumption, sub-plan overhead, and work_mem limitations

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.

Analyzing a classic case where long transactions caused table bloat and slowed down primary key queries: massive dead tuples couldn't be reclaimed by vacuum, forcing primary key scans to traverse bloated pages and causing CPU spikes

Comprehensive analysis of PostgreSQL TRUNCATE command options, including ONLY inheritance behavior, RESTART/CONTINUE IDENTITY sequence reset, and CASCADE behavior

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.

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.