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.
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 systematic deep dive into PostgreSQL localization mechanisms, covering locale, collation rules, character set principles, and their impact on query behavior.