Part 02 · Storage Engine Fundamentals
Databases vs the OS Page Cache
Page cachefsyncO_DIRECTDouble buffering
The OS caches files too, so why does the database keep its own cache? Double buffering, fsync, O_DIRECT, and how PostgreSQL and InnoDB choose differently.
⏱ 6 min · Station 12 of 123