Posts

A summary of common PostgreSQL DDL change pitfalls and clever workarounds — a quick-reference cheat sheet.

Analysis of GRANT authorization causing walsender to freeze: massive pg_class changes from bulk GRANT produce huge numbers of invalidation messages; logical decoding stalls due to pathman plugin's slow hash table traversal during invalidation processing

Deep dive into advanced Linux memory management topics, covering buddy allocator, page tables & TLB, reverse mapping, and NUMA architecture principles.

2024 Year-End Summary: A year of comprehensive PostgreSQL operations, deep reflection on the DBA career future, sharing PG technical books and extracurricular reading rankings

A summary of PostgreSQL operations experience in 2024, covering execution plan regressions, statistics collection strategies, connection pooling, vacuum, WAL, partitioned tables, and other common ops issues with quick diagnosis and resolution approaches

Deep analysis of PG startup flow where the startup process reading tens of millions of spill files causes slow startup, identifying the root cause through source code analysis of LSN structure and spill file naming rules

Deep source code analysis of PG shutdown flow and signal mechanisms, troubleshooting why walsender blocks fast shutdown: logical replication walsender cannot respond to SIGTERM while waiting for consumer feedback

Notes on DDIA: systematically organizing core concepts of OLTP/OLAP, cloud-native, data lakehouse, and excerpts of brilliant insights on distributed data systems

An in-depth analysis of PostgreSQL CLOG file structure and transaction status storage principles, including transaction ID location and standby synchronization mechanisms.

Analyzing near-1-second planning time and over 1 million planning shared hits — root cause is pg_statistic table bloat causing backends to cache excessive dead tuple data during CatCacheMiss on first SQL execution