Starting from a query conflict on a static table, this article dives deep into the root causes of standby query conflicts in PostgreSQL and the principles behind XLOG_HEAP2_CLEAN.
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