杂项

2023 Year-End Summary: A year of comprehensive PostgreSQL learning, including extracurricular reading rankings, reflections on writing and WeChat official account operations, and thoughts on active learning methodology

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.

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.

A mid-2023 rundown of American TV shows I've watched, centered around the Yellowstone series, 1923, 1883, and others — with impressions, personal ratings, and recommendations.