HOW POSTGRES STORES DATA ON DISK

Summary from the TLDR newsletter

Databases contain some immensely powerful and clever abstractions. They aren't that complicated - most of the complexity in them comes from edge cases, often around concurrency. This article looks at how databases store data on disk, with a focus on PostgreSQL. It also provides resources for further research. Understanding how databases work is useful for fine-tuning performance and data recovery.