Tracing 8 KB Reads from PostgreSQL

▤ Summary

This article benchmarks PostgreSQL 17 read performance for 8 KB random access and compares SSD, NVMe, and AWS EBS behavior. It shows how buffer cache state, index scans, and I/O timing affect query latency. The tests highlight a large gap between local NVMe performance and EBS performance under the same workload. It also demonstrates how direct I/O, fsync, and scan patterns can change execution time by an order of magnitude. The piece is useful for anyone tuning PostgreSQL storage, caching, or cloud infrastructure choices.

▦ Linked Companies