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
An in-depth analysis of PostgreSQL streaming replication principles and process architecture, covering synchronous and asynchronous modes and failover switchover mechanisms.
Complete hands-on steps for setting up Oracle GoldenGate PostgreSQL-to-Oracle data synchronization, covering environment configuration, OGG installation, and sync link creation
Sharing my experience of getting into Wuhan University's part-time graduate program, covering differences between full-time and part-time, choosing a major and school, the management exam content, and early interview strategies
An introduction to the pg_rewind tool, its use cases and hands-on steps for resynchronizing after primary-standby timeline divergence, including wal_log_hints parameter configuration.