Analyzing a case where performance dropped after adding an index: the new index caused the optimizer to choose a different execution path, and the cached generic plan prevented ANALYZE from updating the erroneous cached plan
Analysis of how 8 parameters in the control file are synchronized to the standby via PARAMETER_CHANGE WAL records, and the impact of wal_log_hints primary-standby mismatch on pg_rewind
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