PostgreSQL Does Async I/O with io_uring: A Closed-Loop Read-Ahead Controller
PostgreSQL 20’s AIO subsystem has an io_uring backend plus a read-ahead controller that doubles its look-ahead distance only when the backend actually had to wait for I/O.
Performance
tmux Redraws Only What Changed: Five Layers of Less Work
tmux never redraws ’the screen’ — it redraws the difference.
PostgreSQL Hashes Lookups: Dynahash and Simplehash
PostgreSQL has two hash tables: dynahash grows one bucket at a time and never rehashes, while simplehash is a templated open-addressing table that resizes without rehashing a …
PostgreSQL Uses SIMD to Scan Strings Faster: One Vector Layer, Six Consumers
PostgreSQL’s port/simd.h is a portable SSE2/NEON vector layer, and COPY FROM, hex coding, JSON escaping, ASCII validation, linear search and radix-tree lookup all use it to skip …
PostgreSQL Locks Tables Fast: The Fast Path and Sixteen Lock Partitions
Most PostgreSQL locks never touch the heavyweight lock table: weak relation locks live in a per-backend fast path, and the real lock table is split into sixteen …