Posts

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.

An in-depth analysis of replica identity's impact on old/new values in PostgreSQL logical replication, detailing data differences for UPDATE/DELETE under default and full modes.

A comprehensive guide to PostgreSQL declarative partitioning, partition maintenance strategies, and query optimization techniques.

A systematic deep dive into PostgreSQL localization mechanisms, covering locale, collation rules, character set principles, and their impact on query behavior.

A comprehensive collection of PostgreSQL interview questions covering MVCC implementation vs Oracle, table bloat principles, vacuum mechanisms, and core PostgreSQL knowledge