Bilingual, source-visible engineering notes built around useful explanations, reproducible details, and real project context.
Knowledge, made useful
3 articles
Database Engineering
A precise reading of PgBouncer 1.25.2's SQL feature map — SET, prepared statements, temp tables, advisory locks, LISTEN — plus how to size backend and frontend connection limits.
Database Engineering
Equality-first is the hard constraint; sort-vs-range is a cost trade. $in changes category at 201 elements, covered queries fail silently, and 8.3 changed plan selection.
Database Engineering
The eight incompatible changes sorted by how they hurt — hard pg_upgrade refusals, silent behavior changes like JIT off by default and lz4 TOAST compression, and settings needing recalculation — plus REPACK CONCURRENTLY and parallel autovacuum.
