The real cost of random I/O
Summary
The post re-evaluates PostgreSQL's random_page_cost, arguing the default 4.0 is often too optimistic on modern SSDs. It walks through a reproducible experiment comparing sequential and random I/O, shows estimated random_page_cost values much higher, discusses effects on query plans and prefetching, and suggests monitoring and context-aware tuning rather than blindly lowering the parameter.