In-depth analysis of Oracle index split contention wait event enq: TX - index contention, its root causes, and six solutions including reverse indexes, hash-partitioned indexes, and partition table scattering.
Analysis of PostgreSQL's mechanism for initializing the data dictionary via BKI files in bootstrap mode, answering how basic system tables are accessed when pg_class doesn't exist yet
A sharing at the PostgreSQL Technology Summit Chengdu stop, covering the history of transactions, flaws in the ANSI SQL-92 standard, and the implementation of SSI (Serializable Snapshot Isolation) in PostgreSQL
A primer on HikariCP connection pooling: decoding core parameters, connection pool sizing formulas, and analyzing the impact of database connection count on performance with best practices.
Analyzes why a unique index scan accesses multiple data pages due to broken HOT chains and index bloat, diving deep into btree index version management and dead tuple cleanup mechanisms.
Analyzing the root cause of wrong index selection in execution plans: stale statistics at month-end causing predicate out-of-bounds, combined with prepared statement caching preventing plan updates even after ANALYZE.
Troubleshooting a cascading hang where logical replication walsender exhausts memory, triggers replication_slot_io waits, and blocks both checkpoint and backup processes
Analyzing why INSERT VALUES occasionally became slow. Through wait event analysis, the root cause was identified as WALWrite lock contention, where WAL flushing became the bottleneck under heavy concurrent writes.
Reading notes on Wild: a memoir of the author's solo hike on the Pacific Crest Trail, rediscovering herself through a journey into nature amidst loss and pain
Reading notes on When Breath Becomes Air and What Life Should Mean to You — a surgeon's reflections on terminal cancer, and the core ideas of Adlerian individual psychology