Posts

Analyzing the root cause of wrong index selection in execution plans: stale statistics at month-end causing predicate out-of-bounds, combined with prepared statement caching preventing plan updates even after ANALYZE.

Troubleshooting a cascading hang where logical replication walsender exhausts memory, triggers replication_slot_io waits, and blocks both checkpoint and backup processes

Analyzing why INSERT VALUES occasionally became slow. Through wait event analysis, the root cause was identified as WALWrite lock contention, where WAL flushing became the bottleneck under heavy concurrent writes.

Reading notes on Wild: a memoir of the author's solo hike on the Pacific Crest Trail, rediscovering herself through a journey into nature amidst loss and pain

Reading notes on When Breath Becomes Air and What Life Should Mean to You — a surgeon's reflections on terminal cancer, and the core ideas of Adlerian individual psychology

Reading notes on To Kill a Mockingbird: a story of racial prejudice and justice told through a young girl's eyes, with an in-depth analysis of Bob Ewell's death and the 'mockingbird' metaphor

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