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
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