Posts

Reading notes on Arthur C. Clarke's Space Odyssey tetralogy: from the TMA-1 monolith to the ignition of Jupiter, exploring the grand narrative of alien life guiding human evolution

Reading notes on Romance of the Three Kingdoms: delving deep into the strategic chess game at Red Cliffs, distinguishing between later 'embellished' plots and the original text, and interpreting the novel's mystical elements and artistic license

Reading notes on Homo Deus: Yuval Noah Harari explores humanity's new agenda — from conquering famine and plague to humanism, and how Dataism reshapes future society

Reading notes on Chimpanzee Politics: through observations of chimpanzee communities, revealing power alliances, triangular relationships, and the biological roots of political behavior — reflecting on human social power structures

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