Multi-block buffered reads in PostgreSQL 19 (IO combine & prefetch)

PostgreSQL scans operate at the page level: the buffer manager fetches one 8 KB page (BLCKSZ) at a time, issuing one read per block. The operating system may merge some of these requests through readahead, but PostgreSQL still generates many small I/O operations, leading to a high number of system c

Related Stories

What 12 failure classes and 30 Billion tokens spent taught us about trusting AI coding agents

📰

Tech Crush Assignment 5

📰

I stopped putting AWS keys in GitHub Secrets. Here's what I do instead.

📰

Convergence of Calendars: Arabic Date Converter's Hidden Tech Secrets