PostgreSQL JSONB Write Amplification: TOAST Chunk Fragmentation and Unseen I/O Thrashing
Why a one-key jsonb_set() rewrites the whole document, and how to stop JSONB from flooding your WAL
#performance
Posts tagged #performance
Server-Sent Events (SSE) Backpressure Breaks: Memory Leaks and Socket Starvation in High-Throughput LLM Pipelines
How slow clients leak memory in Node.js LLM streaming, and how drain-aware backpressure and abort handling prevent it
PostgreSQL MVCC Autovacuum Starvation: HOT Update Breakdown & Table Bloat under Heavy Write Loads
Why HOT updates break under heavy writes, and how fillfactor and per-table autovacuum tuning fix table bloat