Skip to main content

Rethinking PostgreSQL buffer mapping for modern hardware architectures

· 6 min read
Alexander Korotkov
Creator of OrioleDB

Traditional database engines were designed in the '80s and early '90s. At that time CPUs were much slower than they are today. Even worse was storage, hard drive head positioning time was enormous1. And CPU (or, at most, a few single-core CPUs) was assumed to be infinitely fast in comparison to IOPS. Therefore, systems were designed to save IOPS as much as possible, while CPU overhead was considered a secondary optimization target.

Footnotes

  1. Numbers Every Programmer Should Know By Year - Colin Scott