Posts

Notes on Sapiens: from the Cognitive Revolution to money and empire, how Homo sapiens built civilization through the power of fiction, exploring humanity's grand journey from animals to gods

Notes on Rich Dad Poor Dad: the core idea that 'the poor work for money, while the rich make money work for them,' exploring financial literacy and the gap between passive and active learning

Notes on Elon Musk: from Zip2 to SpaceX and Tesla, the legendary entrepreneurial journey of disrupting multiple industries with the ultimate mission 'for humanity'

Notes on Educated and Atomic Habits: a legendary true story of how education transforms destiny, and the scientific methodology of building good habits

Notes on Average Is Over: exploring the risk of the middle class being displaced in the AI era, rising learning costs, and intensifying polarization in the future

Root cause analysis of a 35-minute partition creation: a 50GB default partition requires full data validation when adding a new partition to ensure no range conflicts

Analyzing the trigger conditions for VACUUM truncation of trailing empty pages, diving into the should_attempt_truncation function source code and the REL_TRUNCATE_MINIMUM threshold.

Explaining vector database core concepts from the ground up, covering embeddings, RAG (Retrieval-Augmented Generation), and LLM fundamentals.

Analyzing why UPDATE fails with 'too many range table entries' while SELECT succeeds: UPDATE triggers all partitions in the plan, causing range table entries to exceed the 65000 limit

Analyzing why a table did not appear in the execution plan of a LEFT JOIN query. The root cause is that the optimizer removed the outer table through JOIN elimination optimization when none of its columns were needed in the output.